>Hello All:
>I having working on a project that uses sqlexec()for different sql statements. >Where could find information on syntax. What will be the correct syntax for sql with and statement:
>m.client_id = "test"
>m.totquote = 2
>sqlexec(handle, "select * from quotetype where qtclientid = ?m.client_id and qtquotekey = m.totquote","mycursor")


Hello Sherry,
Try this:

 mysql = "select * from quotetype where qtclientid = m.client_id "
 mysql = mysql +" and qtquotekey = m.totquote "
 lnResult = SQLEXEC(lnhandle,mysql,'mycursor') 

Is the user going to enter this information on the fly or will they enter it from an entry screen of some sort?

HTH