Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQLEXEC
Message
 
To
23/03/2005 01:21:12
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00998336
Message ID:
00998339
Views:
15
Check with AERROR()
qhandle = SQLSTRINGCONNECT(;
		'driver=SQL server;' + ;
		'Server=(local);' +;
		'database=master;' + ;
		'uid=SA;' + ;
		'pwd=SA;' + ;
		'trusted_connection=YES')
IF qhandle < 0
   AERROR(aErr)
   DISPLAY MEMO LIKE aErr
   RETURN
ENDIF
IF SQLEXEC(qhandle,'SELECT * FROM MASTER','QMASTER') < 0
   AERROR(aErr)
   DISPLAY MEMO LIKE aErr
   SQLDISCONNECT(qhandle)
   RETURN
ENDIF

SELECT QMASTER
...
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