[fdo-users] Re: IInsert and Property Values and Using Sequences Question

[Haris Kurtagic]

On the side note;
King.Oracle will automatically use sequence for primary key if
specific naming is followed ( _fdoseq ).
It is described here: http://www.sl-king.com/fdooracle/KingOracleSetup.html .
Insert in King.Oracle is done in two steps, first get next sequence
value and then insert row with the value.

Haris

On Fri, Oct 15, 2010 at 10:08 AM, Crispin_at_1Spatial
<crispin.hoult at 1spatial.com> wrote:
>
> Thanks Jackie (and Romy),
>
> I'll take that as definitive for now.
>
> Two camps here I guess
>
>  1) To have a IInsert / IUpdate property value that is just a value - hence
> as a string not quoted when it gets parsed by FDO and turned into SQL at the
> provider level.  This is flexible but does requires DB specifics such as
> 'sysdate' for oracle or 'Now()' for SQL so is non transferrable
>
>  2) To allow computed or function expressions that would be tricky to manage
> at the provider level to ensure the datatype returned from the function
> matched the property in the datastore.  And I'm not sure if the Oracle
> sequence example would fit into either a computed value or a function?
>
> Back to DB triggers...
>
>  Crispin
>
>
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/IInsert-and-Property-Values-and-Using-Sequences-Question-tp5635940p5638011.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
>