Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to Microsoft Access
Message
From
13/04/2004 00:56:36
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/04/2004 16:28:46
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00894192
Message ID:
00894311
Views:
7
>And how to I access the results of that query?

At that point, you got a SPT cursor - which is just another readwrite cursor. The last parameter was the alias of that cursor.

There are tricks to make such cursors read-write, but that involves a lot of cursorsetprop()s and similar tricks, where you need to know the original field names, primary keys etc. Doesn't work right away, but works eventually.

Another approach is to create a connection into the Access database and just create remote views. They are easier to make updatable - though I've never run them against Access, only SQL server.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform