Jack
Wed Jun 07 12:51:03 CDT 2006
I had lots of problems getting CursorAdapters to work in VFP8 and
found a couple of bugs. Don't know if things are better in VFP9.
Mark McCasland has written a lot of CursorAdapter code. His and some
other stuff is on this page:
http://www.universalthread.com/wconnect/wc.dll?2,54,1,5
Functions like REQUERY() and TABLEUPDATE() work with CursorAdapters,
but remote views and SQLEXEC don't.
What I did was to get the info from my remote views at runtime and
create a CursorAdapter on the fly. I also created a wrapper for
SQLEXEC that would create a temporary CursorAdapter.
On Tue, 6 Jun 2006 20:56:23 -0700, "Ook"
<nousenetspam@zootal.nospam.com> wrote:
>Huh - know of any good examples? VFP docs leave a bit to be desired. Never
>had a chance to play with cursor adaptors.
>
>"Jack Jackson" <jacknospam@pebbleridge.com> wrote in message
>news:8gic829edfm93j04uc2svkk9ufj2g3d74v@4ax.com...
>> On Tue, 6 Jun 2006 20:28:51 -0700, "Ook"
>> <nousenetspam@zootal.nospam.com> wrote:
>>
>>>I can create remote views using odbc - have done so for years. But how do
>>>you do it with oledb? It won't accept my connection string and selecting
>>>an
>>>existing dsn seems to only use odbc.
>>
>> You need to use a CursorAdapter.
>