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:11:48
 
 
To
24/11/2000 18:48:12
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00445283
Message ID:
00445297
Views:
17
lcSQL = 'Select * from Person'

Contents of laError:
[1,1] 1526
[1,2] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Person'.
[1,3] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Person'.
[1,4] S0002
[1,5] 208
[1,6] 13
[1,7] NULL

Sounds like my table name's not specified correctly. I've also tried person.dbf, dbo.person, dbo.peraon.dbf. I'm obviously not specifying the backend table name correctly. This is an upsized VFP database, and the original table in question is person.dbf, in case you hadn't guessed :-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform