[fdo-internals] IInsert.BatchParameterValues problems

[Orest Halustchak]

Hi Maksim,

Did you check if the provider that you're using supports this capability? Check FdoICommandCapabilities::SupportsParameters.

Note that some providers may do buffering internally so that even if you call IInsert.Execute many times, internally those inserts are buffered and use array inserts to the underlying server.

Thanks,
Orest.

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Maksim Sestic
Sent: Tuesday, March 04, 2008 5:25 AM
To: fdo-internals at lists.osgeo.org
Subject: [fdo-internals] IInsert.BatchParameterValues problems


It's FDO 3.2.0 in question. I'm asking this because managed
IInsert.BatchParameterValues cannot get instantiated via newing, and it's
Nothing (Null) by default when IInsert is created. Since
IInsert.BatchParameterValues is read-only property, there's no way to add a
new instance of it and populate the collection with
ParameterValueCollections for each row.

Regards,
Maksim Sestic


Maksim Sestic wrote:
Hi all,

Is there any example of how to use managed IInsert.BatchParameterValues
collection to insert many features in a batch? I'm currently using
IInsert.PropertyValues.Add(...) with consecutive IInsert.Execute to fill the
datastore row-by-row, but this fails when there're thousands of rows.

Regards,
Maksim Sestic
--
View this message in context: http://www.nabble.com/IInsert.BatchParameterValues-problems-tp15824346s18162p15824346.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