Limited number of Insert statements in CommandText... 
Author Message
 Limited number of Insert statements in CommandText...
Does anyone know if there is a limit to the number of Insert statements you
can pass to the CommandText object?  I am sending about 91 different Insert
statements all at the same time, yet only 50 or so get inserted into the
database.  The database we use is Sybase 12.0 and ADO version 2.5.

Any ideas to get around it is greatly appreciated.

Warren



Tue, 31 Aug 2004 04:05:10 GMT
 Limited number of Insert statements in CommandText...

Because of our limitation in our attempt to send multiple inserts by use of
the CommandText, we've discovered an easy solution.  By changing our XSL,
which transforms our XML into multiple Insert statements, to end every
Insert with a "|", we were able to use the Split function on the string
separating it into individual insert statements.  With a For Loop, we now
run the Inserts separately on the database.  This did not even have a
performance lag as I initially suspected it to.

Hope this helps for someone else with a similar problem.

Warren


Quote:
> Does anyone know if there is a limit to the number of Insert statements
you
> can pass to the CommandText object?  I am sending about 91 different
Insert
> statements all at the same time, yet only 50 or so get inserted into the
> database.  The database we use is Sybase 12.0 and ADO version 2.5.

> Any ideas to get around it is greatly appreciated.

> Warren



Tue, 31 Aug 2004 22:16:52 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ADO, Command, CommandText, String Limit

2. Limit Number of Recordset Return from SELECT statement

3. Limiting number of records returned by the SELECT statement

4. Limit Number of Recordset Return from SELECT statement

5. Limit on number of sql statements exceeded

6. How to limit the number of rows returned in a select statement

7. Returning a limited number of rows from a SELECT statement

8. 4GL err -257: System limit on maximum number of statements exceeded

9. 4GL err -257: System limit on maximum number of statements exceeded

10. BULK INSERT limit on number of columns

11. Limiting Row-Locking on large INSERT Statements

12. Determining the specific sequence number generated on an insert statement


 
Powered by phpBB® Forum Software