Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting MDB to DBF
Message
 
To
22/06/2005 09:23:45
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01025422
Message ID:
01025424
Views:
14
lcmdb=("c:\HJSDB.mdb")
Store SQLSTRINGCONNECT(;
	'DBQ='+lcmdb+';'+;
	'Driver={Microsoft Access Driver (*.mdb)}');
	TO gnConnHandle

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

IF NOT SQLEXEC(gnConnHandle,"select * from lcmdb","myCURSOR") < 0  && W/o ; at the end of SELECT
  AERROR(laErr)
  DISPLAY MEMO LIKE laErr
  SQLDISCONNECT(gnConnHandle)
  RETURN
ENDIF
Select myCURSOR
Copy TO C:\PHONE.DBF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform