Additionally, I have CA samples and a CA VCX Builder on my website. All source code included. I have extensive comments near the beginning of my CA Builder PRG file that you may find useful. Just click the FoxPro Tools link at
http://www.mctweedle.com>Hi,
>
>I built my own Client/Server framework that uses SQL Passthru to get cursors into forms and then either issues tableupdate/revert or stored procedures to update the data. I get a connection handle at the beginning of the application and then use this handle to get data, update, etc.
>
>Basically I've used it to work with SQL data and now I want to upgrade it to also work with Foxpro data, but of course in a Client Server way.
>
>The ideal is that it works the same way as before (a connection and bringing cursors into the forms) but the connection is getting foxpro data instead of SQL Server data.
>
>
>What approaches do you guys suggest?
>
>I just began reading about CursorAdapters and seems like a possible candidate. Do they work with connection handles? How about other approaches?
>
>Thanks.
Mark McCasland
Midlothian, TX USA