Just for reference, I figured this one out.
The 24000 SQL state error 0 can be caused by a bug in the VFPODBC driver that was fixed (but maybe not). If data is small, no error. So just used nodata on the cursor. Thanks.
>I am connecting from VFP 5.0 into a Remote VFP 5.0 database. I get the following message
>
>ODBC Error Message: "Connectivity error: [Microsoft][ODBC Driver Manager] Invalid cursor state"
>
>ODBC SQL state: "24000"
>
>The error number from the ODBC data source: 0
>
>Can anyone tell me what is really going on, and what to do about it? Thanks.
EMail: danielj@ryte-byte.com
"If I'm paddling so hard, how come I'm going backwards?" - Pinocchio (while the whale was swallowing him...)