Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00515140
Message ID:
00515939
Views:
16
Vlad:
Sorry to bother you again. I am getting an error on this command:
m.client_id = "test"
m.totQuote = 2
sql_str = "select * from quotetype where qtclientid = ?m.client_id and qtQuoteKey = ?m.totQuote"

the error I got: [1,1]1526[1,2]totQuotes [MICROSOFT][ODBC ACCESS DRIVER] TOO FEW PARAMETERS. EXPECTED 5.

It works if I use signle criteria in the WHERE clause. What will be the syntax for this sql? This is my first using sqlexec(). Thanks
sherry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform