[fdo-users] Bulk Insert in Sqlite

[Traian Stanev]

For bulk inserts, you can reuse the Insert command and its parameter collection -- internally the provider does its own batching, so you don't have to do it manually. There was a thread about this recently.

Traian


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
Sent: Monday, May 31, 2010 11:05 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Bulk Insert in Sqlite


I'm trying to do a bulk insert in the Sqlite provider ( the 3.6 version in
the trunk )

FdoPtr<FdoIInsert> insertPtr   =
(FdoIInsert*)connectionPtr->CreateCommand(FdoCommandType_Insert);
FdoPtr<FdoBatchParameterValueCollection>  batchParamPtr =
insertPtr->GetBatchParameterValues();

my batchParamPtr is always null, normally this is when the providers does
not support batch insert

I know it should work because BulkCopy in Map3D 2011 works well with the
same Sqlite provider.

What's the trick?

Bruno
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Bulk-Insert-in-Sqlite-tp5122126p5122126.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users