>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
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson