Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC and the underscore
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQLEXEC and the underscore
Miscellaneous
Thread ID:
00615659
Message ID:
00615659
Views:
48
I have a non-Fox legacy database that I am pulling data out of with a SQLEXEC command. The key field has an underscore in the name ( ID_ ). I am using the following code

QueryString = 'SELECT * FROM SOURCE WHERE ID_ = 2541'
Results = SQLEXEC( handle, QueryString, 'TARGET')

This code is failing because of the underscore in the name of the ID Field. Is there a way around this?
Next
Reply
Map
View

Click here to load this message in the networking platform