Hi Sherry,

I see in the error message [1,2]totquotes
where is totquotes used in the SQL statement?

Glenn

>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