You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
Update: This seems very inconsistent. Sometimes it doesn't work at all. Attempting to store 10 rows results in only the first row, and pirow parameter isn't updated at all. Also, running an update again once there is an existing row often only updates that existing row, and pirow is left untouched again.
The text was updated successfully, but these errors were encountered:
description: Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
=>
Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
Update: This seems very inconsistent. Sometimes it doesn't work at all. Attempting to store 10 rows results in only the first row, and pirow parameter isn't updated at all.
description: Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
Update: This seems very inconsistent. Sometimes it doesn't work at all. Attempting to store 10 rows results in only the first row, and pirow parameter isn't updated at all.
=>
Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
Update: This seems very inconsistent. Sometimes it doesn't work at all. Attempting to store 10 rows results in only the first row, and pirow parameter isn't updated at all. Also, running an update again once there is an existing row often only updates that existing row, and pirow is left untouched again.
summary: Bulk inserts on Prepared statements only insert one row when the table is empty => Bulk inserts on Prepared statements only inserts the first row
Submitted by: Alan Marryat (amarryat)
Using SQLPrepare, binding columns, SQLParamOptions to insert multiple rows at once.
When the table is empty, attempting to insert 10 rows for example results in 1 new row, equal to the first bound row. The pirow parameter in SQLParamOptions remains at 0 or 1 or whatever you initialized it to.
The next time you do the bulk insert with 10 rows for example, all 10 rows will be inserted and the table will now contain 11 rows. pirow parameter is updated correctly.
Update: This seems very inconsistent. Sometimes it doesn't work at all. Attempting to store 10 rows results in only the first row, and pirow parameter isn't updated at all. Also, running an update again once there is an existing row often only updates that existing row, and pirow is left untouched again.
The text was updated successfully, but these errors were encountered: