Hi Gang....

Yes, VFP numerics can work with ADO....sort of. Here is the deal, if you have a client-side cursor, attempting to update a numeric will fail. If however, you happen to have a server-side cursor - updates to numerics work.

Still, there are many limitations to accessing VFP data with ADO - at least as far as updates are concerned. Client-side cursors provide functionality not found in server-side cursors. Specifically - support for sorting, indices, state-less connectons, persisted recordsets - can only be found with client-side ADO recordsets.

So, I still stand by my contention that there is an incompatibility with VFP numerics and ADO. The solution - use doubles instead.

I hope this closes the book in this issue ....< s >