I had guessed that's the sql way. What I was actually looking for was if data could be used in c# without it being server driven. In other words data like vfp uses it. The disconnect is fine but I was looking for I suppose the equivalent of free tables in VFP. Al
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions General Account In that case, you'll need to understand that data access from the others is (iirc) done via ADO recordsets. You establish a connection (similar to the handle in VFP), then issue commands and get back recordsets. There's several things online for ADO. Not too hard. Just try and relax and realize that you just work with disconnected data (instead of constant connection like classic Fox). You get what you need in its local dataset, do your data manipulations (add/edit/delete), then send back the changes. Or you could use the recordsets as a read-only cursor and then do the add/update/delete using SQL on the backend data, then just requery your local datasets....like cursors, but slightly different. Good luck, Al! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
