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