Thanks, I will try your tests.

After more tests it is more strange than I had thought.

If I issue the CursorRefresh() multiple times in a row it alternates between the the view defintion error and an ODBC error: Connectivity error: [IBM][Client Access Express ODBC Driver (32-bit)]Invalid cursor state.

The exe is located on a network. When I run the app from a different computer it does not happen.

When I build the app under a different exe name it does not happen on either machine.

I am thinking it has more to do with the AS400 ODBC driver than anything else.



>I think you might guess this could be hell to troubleshoot. My guess is the handling of integer/numeric conversion between DB2 and the VFP cursor. Can you test this with a DBC and a remote view and get the same results/error?
>
>Using the CA, you could also try to narrow down which data type is causing the error. Eliminate all the integer fields from the SELECT field list. Test. If OK, add back the integer fields, remove date fields. Test. You may just test with fields of one data type only. Once you have nailed down what data type is causing the error, then we can move on from there.
>