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

Crispin_at_1Spatial crispin.hoult at 1spatial.com
Fri Oct 15 04:08:28 EDT 2010

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.

More information about the fdo-users mailing list