The way I do this is: Subclass a DE and set the connection properties. Subclass a CA and tell it to use the DE connection Add the DE to the form and change the DEClass property
There's loads more stuff but that's the basic. (I'll send you some code if you like). Laurie On 3 August 2015 at 11:38, Dave Crozier <[email protected]> wrote: > Fellow VFP Foxphiles, ladies and gentlemen, > I normally do all my Remote SQL through SQL Pasthrough but Tom here is > branching out into Cursor Adapters which I dabbled with just after VFP8 and > just before VFP9 and resorted to the SPT methods as the preferred method of > accessing remote data. > > So, question as I know I have done it before but the old brain cells just > ain't functioning today!! > > > 1. Made up a subclassed cursoradapter for a table on SQL server - > test connectivity ... OK > > 2. DataEnvironment on a form ... go into builder and add in the > subclassed CA above ... no problem > > 3. Add grid on the form with recordsource set to cursor just created > in DE ... no problem > > 4. Cursor set to fetch all records > > 5. Open the form and no data pulled back from the remote source at > all. I have looked at the before fill(), fill() methods on the cursor as > well as the beforetableopen() in the DE and no data ever passes back to > VFP. It is just as though the cursor is set to open without data fill which > I have checked of course. > > > > Question: > > How to automatically retrieve the data into the CA....i am sure that > something pretty basic is not being done here but despite readiing Megafox, > 1001 things as well as the CA sections in what's new VFP8 and 9 I can't > figure it out but it is pretty basic of that I am sure. > > > > This is driving me totally mad now and I have tried attaching the CA to > both remote SQL sources as well as using the ODBC link back to a local VFP > database/table which gives exactly the same result. > > > > I know I can do the whole process programmatically using either SPT or > CA's as I have done both but it would be preferable to use the subclassed > CA's in the DE in exactly the same way you use native tables. > > > > Dave > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/camvtr9e6ln6ttxwzjlbvlcxdj0njycwxmfyo3qd8sjnqeqm...@mail.gmail.com ** 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.
