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.<div><br></div><div>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.<div>
<br></div><div>Jason<br><br><div class="gmail_quote">2009/12/20 Matteo<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Hi Jason,<br>
thanks for the answer. I need a general solution for Oracle and other FDO<br>
provider (ex. SDF, SHP). I think that I can calculate the MAX of the<br>
IdentityProperty through FDO Command (ISelectAggregate or ISQLCommand. But I<br>
don't know how and I don't find documentation/samples.<br>
Can you help me?<br>
Regards<br>
Matteo<br>
<div><div></div><div class="h5"><br>
<br>
Jason Birch wrote:<br>
><br>
> Have you considered setting the oracle table up with a trigger that<br>
> inserts the next value from a sequence?<br>
><br>
> I think king.oracle may have some special naming-convention-based<br>
> handling around sequences that the trigger may not be required... I<br>
> haven't used it for a while though so not sure.<br>
><br>
> Jason<br>
><br>
> On 2009-12-20, Matteo <<a href="mailto:matteo.conte1979@libero.it">matteo.conte1979@libero.it</a>> wrote:<br>
>><br>
>> Hi all,<br>
>> I have a class in OracleXE with FeatId as IdentityProperty<br>
>> (autogenerate).<br>
>> The class isn't void. When I try to insert new feature in the class I get<br>
>> an<br>
>> error because I haven't compile the FeatId column. How I can retrieve the<br>
>> max value of FeatId column using <a href="http://VS.NET" target="_blank">VS.NET</a>? I use King provider<br>
>> Regards,<br>
>> Matteo<br>
>> --<br>
>> View this message in context:<br>
>> <a href="http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4194807.html" target="_blank">http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4194807.html</a><br>
>> Sent from the FDO Users mailing list archive at Nabble.com.<br>
>> _______________________________________________<br>
>> fdo-users mailing list<br>
>> <a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
>><br>
> _______________________________________________<br>
> fdo-users mailing list<br>
> <a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
><br>
><br>
<br>
</div></div><font color="#888888">--<br>
View this message in context: <a href="http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4196163.html" target="_blank">http://n2.nabble.com/Insert-object-on-a-existing-SHP-file-tp4194807p4196163.html</a><br>
</font><div><div></div><div class="h5">Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
</div></div></blockquote></div><br></div></div>