I am experimenting with ADO as a substitute for remote views in a VFP app we need to move to SQL Server. On the surface it appears a natural fit that would preserve the functionality of our navigation buttons (a key requirement). The use of dynamic, server-side cursors for better performance and automatic refreshing of data is very appealing (at least to my boss).

Using a simple VFP form (built from the VFP base classes) I've been able to load and navigate through the cursor, but it is really fighting me trying to do an update. The textbox controlsource properties are all set to reference the recordset object directly (ex: "thisform.orecordset.fields('vendornum').value"). When VFP is first loaded and I edit the textbox contents, then tab off, an error occurs. Cancelling out - close all, clear all, etc - and re-running the form is even more disastrous. The form hangs. You can't close it, or even shut down VFP.

So I have two questions:
1) Can the recordset.field collection values be manipulated directly like this? John Petersen did a presentation at Devcon that implied that this should work. Or maybe I slept thru a warning or two...

2) Has anyone out there been able to get ADO to work for them at all? This exercise sure has been a PITA. Am I just being dense, or is it really as difficult as it seems?

Any help/encouragement at this point would be greatly appreciated.