[fdo-users] Insert object on a existing SHP file

[Jason Birch]

Unless both support explicit transactions and you use them, selecting MAX is
not a good choice in a multi-user environment; not ACID.  Regardless, I
don't have example of this for you; sorry.

Does the datastore creation need to be generic cross-provider? SDF supports
auto-increment, and as Haris just confirmed, king.oracle will too if you are
inserting to a table with a PK and where there is a sequence with the same
name as the table + _FDOSEQ.

Jason

2009/12/20 Matteo

>
> Hi Jason,
>  thanks for the answer. I need a general solution for Oracle and other FDO
> provider (ex. SDF, SHP). I think that I can calculate the MAX of the
> IdentityProperty through FDO Command (ISelectAggregate or ISQLCommand. But
> I
> don't know how and I don't find documentation/samples.
> Can you help me?
> Regards
> Matteo
>
>
> Jason Birch wrote:
> >
> > Have you considered setting the oracle table up with a trigger that
> > inserts the next value from a sequence?
> >
> > I think king.oracle may have some special naming-convention-based
> > handling around sequences that the trigger may not be required... I
> > haven't used it for a while though so not sure.
> >
> > Jason
> >
> > On 2009-12-20, Matteo <matteo.conte1979 at libero.it> wrote:
> >>
> >> Hi all,
> >>   I have a class in OracleXE with FeatId as IdentityProperty
> >> (autogenerate).
> >> The class isn't void. When I try to insert new feature in the class I
> get
> >> an
> >> error because I haven't compile the FeatId column. How I can retrieve
> the
> >> max value of FeatId column using VS.NET? I use King provider
> >> Regards,
> >> Matteo
> >> --
> >> View this message in context:
> >>
> http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4194807.html
> >> Sent from the FDO Users mailing list archive at Nabble.com.
> >> _______________________________________________
> >> fdo-users mailing list
> >> fdo-users at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/fdo-users
> >>
> > _______________________________________________
> > fdo-users mailing list
> > fdo-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/fdo-users
> >
> >
>
> --
> View this message in context:
> http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4196163.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20091220/c769241d/attachment.html