General information
Title:
ODBC Error during SQL INSERT command
Hello Experts...
I am encountering a problem. I am updating (Insert/Update) VFP tables via SQL passthrough. It works fine for small batches. But when inserting a large # of records (500+) I get an ODBC error. It usually happens at during the INSERT command. The error will start only after inserting 500+ records.
*-- partial sample code:
lcSQL = "INSERT INTO history (trn_numb, trn_date,... id " +;
" VALUES (?trn_numb, ?trn_date,... lnId "
=ExecuteSQL(lcSQL)
Any idea what causes it. Do I need to fine tune the ODBC connection.
Thank you in advance
Raza Malik
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only