>Mark:
> I tried that it returned the same error:too few parameters. expeced 1. any idea,thanks
>sherry
Sorry, just saw that your second parameter is numeric. Try:
lcSQL = "select * from quotetype where qtclientid = '" + m.client_id + "' and qtquotekey = " + transform(m.totquote)
SQLExec(lnHandle, lcSQL, "MyCursor")
Mark McCasland
Midlothian, TX USA