[fdo-users] Re: IInsert and Property Values and Using Sequences
haris at sl-king.com
Fri Oct 15 04:33:39 EDT 2010
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.
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...
> 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
More information about the fdo-users