[fdo-internals] IInsert.BatchParameterValues problems

[Maksim Sestic]

Hi Orest,

If I understood well - in case provider does support parameters, managed
IInsert will get instantied with BatchParameterValues propery containing
empty BatchParameterValuesCollection collection. Otherwise - the property is
Nothing (Null)... Something's strange here, the collection should exist in
first place neverthless of provider's capabilities (it should throw an error
afterwards, on IInsert.Execute). 

Is this an error in managed wrapper or a feature? :-)

Regards,
Maksim Sestic



Orest Halustchak wrote:
> 
> 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
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> 
> 

-- 
View this message in context: http://www.nabble.com/IInsert.BatchParameterValues-problems-tp15824346s18162p15847951.html
Sent from the fdo-internals mailing list archive at Nabble.com.