>I am trying to look for a specific record using SPT but the following doesn't seem to work, it gives me all the records. I want parameter "g" to work. I am writing this statement wrong? I am trying to retrieve this from access database. g = '444-44-4444'
lcSql = " Select *" ;
+ " FROM UDFields" ;
+ " where UD.SSNo = (g)" ;
lnRes = SQLEXEC( .nCon, lcSql, "lcresults" )
You can try with this code.
g = '444-44-4444'
lcSql = " Select *" ;
+ " FROM UDFields" ;
+ " where UD.SSNo = ?g"
lnRes = SQLEXEC( .nCon, lcSql, "lcresults" )
