Re: Inserting Rows in Bulk

Hello,

With the SQLBindParameter call you can bind multi values to each parameter, so you can insert multi rows in one call.

E.g. if you use an insert statement like "insert into XX(x, y, z) values(?, ?, ?)", you can specifiy an array of values for the 3 parameters with SQLBindParameter.

When you execute the statement, all values will be inserted at once.

Greetings,
Hans Bos.

FaheemRao <faheemrao_at_yahoo.com> wrote in message news:43b58913.0110021349.2dc275f3_at_posting.google.com...
> I want to insert many rows in one Database Call.
>
> like in the Insert SQL statement
>
> insert table_name values(........);
>
> but this will insert only one row in the database.
>
> My Application code is inserting a huge amount of data at one time, so
> it is taking a longgggg time to insert thousands of records.
>
> My application is connected to Oracle through ODBC.
>
> so I need something through which I can insert X number of rows at one
> database call so to take les time.
>
> Any help wuld be apprecited..
>
>
> Thanks
>
>
> Faheem Rao
Received on Wed Oct 03 2001 - 13:23:50 CDT