John Baird
Coatesville, Pennsylvania, United States
General information
Title:
Help with vfp and SQL
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only