Hi,

Try lcSQL= "SELECT * FROM Students WHERE loginId='"+lcStudentID+"'"
I think ODBC or SQL Server doesn't like "" for sring delimitation.
You must use '' instead...


>Can anyone tell me why this code is not returning any values from the Connection. If I use the Interactive SQL query program that comes with SQL 6.5, and give it [Select * from students where loginid="john"], the query returns the expected results. If I use the program below, gnConnHandle is a positive integer; however, lnResult is -1 and the query returns nothing.
>
>If I try this with lcSQL = "Select * from students" it works just fine. It seems that the where clause is causing the problem. What am I overlooking? Using vfp5.0, sql6.5, nt4.0
>
>STORE SQLCONNECT('MyDataBase', 'sa') TO gnConnHandle
>IF gnConnHandle <= 0
> RETURN
>ENDIF
>
>lcStudentID='john'
>lcPassword = 'n'
>lcSessionId=''
>
>lcSQL = 'SELECT * FROM students WHERE Loginid="' + lcStudentID +'"'
>lnResult = SQLEXEC(gnConnHandle, lcSQL, 'cStud')
>SELE cStud
>brow
>IF _TALLY = 0
> **-- generate error
> RETURN "Bad Student ID"
>ENDIF