[fdo-internals] Re: insert error control properties with KingOracle

[Simon Pelicon]

Hi!

This is my sample code. I have no problems inserting strings ,integers and
geometry etc. in one Insert command.
All values are inserted.

*          IInsert  insertCommand =
(IInsert)m_Conn.CreateCommand(CommandType.CommandType_Insert);*
*          insertCommand .SetFeatureClassName("ELECTRO_DATA")*
*          FgfGeometryFactory factory = new FgfGeometryFactory();*
*          IDirectPosition position =
factory.CreatePositionXYZ(Objekt.StartPoint.X, Objekt.StartPoint.Y, 0.0);*
*          IPoint point = factory.CreatePoint(position);*
*          insertCommand.PropertyValues.Add(new
PropertyValue(GEOMETRY_COLUMN, new GeometryValue(factory.GetFgf(point))));*
*          insertCommand.PropertyValues.Add(new
PropertyValue(ROTATION_COLUMN, new StringValue(bref.Rotation.ToString())));*
*          insertCommand.PropertyValues.Add(new PropertyValue(LAYER_COLUMN,
new StringValue(bref.Layer)));*
*          insertCommand.PropertyValues.Add(new PropertyValue(BLOCK_COLUMN,
new StringValue(bref.Name)));*
*          insertCommand.PropertyValues.Add(new
PropertyValue(XSCALE_COLUMN, new DecimalValue(bref.ScaleFactors.X)));*
*          insertCommand.PropertyValues.Add(new
PropertyValue(YSCALE_COLUMN, new DecimalValue(bref.ScaleFactors.Y)));*
*          insertCommand.PropertyValues.Add(new
PropertyValue(ZSCALE_COLUMN, new DecimalValue(bref.ScaleFactors.Z)));*
*          insertCommand.PropertyValues.Add(new
PropertyValue(PROJEKAT_COLUMN, new Int32Value(ProjectID)));*
*
*
*           reader = command.Execute();*
*           if (reader.ReadNext())*
*            {*
*
*
*            }*
           *reader.close();*

What are the Oracle Data Types in the Oracle table?


Regards,
Simon



On Wed, Nov 30, 2011 at 4:40 PM, mdelsinne <mdelsinne at gmail.com> wrote:

> If I do declare no geometry column, Oracle ID inserted. If there is a
> geometry column no ID and no primary key.
>
> But also why he never inserts while the other values is a simple string.
>
> Have you any idea?
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/insert-error-control-properties-with-KingOracle-tp7046704p7047193.html
> Sent from the FDO Internals mailing list archive at Nabble.com.
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20111201/e4501c6c/attachment.html