Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
READING FROM AN ACCESS DB - PROGRAMATICALLY
Message
 
To
16/11/2001 08:51:42
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00582659
Message ID:
00582665
Views:
18
For example:
*--------------------
store SQLSTRINGCONNECT(;
'DBQ=c:\foxwork\Branded Foxpro Projects.mdb;'+;
'DefaultDir=c:\;'+;
'Driver={Microsoft Access Driver (*.mdb)}');
TO gnConnHandle

IF gnConnHandle <= 0
= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
return
Endif

=SQLEXEC(gnConnHandle, "SELECT * from contacts;", "temp")
=sqldisc(0)
*---------------------------

>CAN ANYONE GIVE ME SOME POINTERS ON HOW I CAN PROGRAMATICALLY READ DATA FROM AN ACCESS DATABASE.
>
>REGARDS
>COLIN BURTON
Previous
Reply
Map
View

Click here to load this message in the networking platform