Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC not working with variable as parameter
Message
From
24/11/2000 19:25:37
 
 
To
24/11/2000 19:11:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00445283
Message ID:
00445298
Views:
20
But I guess this still doesn't address the issue of why the explicit phrase works, but the lcSQL variable does not:

lcSQL = 'Select * from Person'

=SQLEXEC(lnConnectHandle, "Select * from Person", "tCursor") works

=SQLEXEC(lnConnectHandle, lcSQL, "tCursor") doesn't. Neither does &lcSQL, '&lcSQL', (lcSQL), or Eval(lcSQL)...
Previous
Reply
Map
View

Click here to load this message in the networking platform