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

Crispin_at_1Spatial crispin.hoult at 1spatial.com
Thu Oct 14 13:38:34 EDT 2010


Hi,

I have a DB (Oracle but hey, it's FDO) that I want to use a sequence
identifier as a property value.

It was too much to get the code below to work - so where should I be
looking?

The StringValue is obviously taken as a literal string but I want it to be
evaluated by the time it gets to the database.  I thought of a
expression.Function but then can't insert that into a
PropertyValueCollection...

 Thanks in advance - Crispin


OSGeo.FDO.Commands.PropertyValueCollection colpvFixedAttributes = new 
     OSGeo.FDO.Commands.PropertyValueCollection();

OSGeo.FDO.Expression.StringValue valueSequenceID = new 
     OSGeo.FDO.Expression.StringValue("work_lr_line_id_seq.nextval");

colpvFixedAttributes .Add(new OSGeo.FDO.Commands.PropertyValue("ID",
valueSequenceID));

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/IInsert-and-Property-Values-and-Using-Sequences-Question-tp5635940p5635940.html
Sent from the FDO Users mailing list archive at Nabble.com.


More information about the fdo-users mailing list