try:
ctemp = ALLT(THISFORM.TXT_PATLNAME.VALUE) + "%" && SQL wildcard ('*' in os)
SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) like m.cTemp GROUP BY PAT_LNAME INTO CURSOR CURPAT
>i have set ansi off now. still pulling more records than it should. here's the sql statement
>
>SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) = ALLT(THISFORM.TXT_PATLNAME.VALUE) GROUP BY PAT_LNAME INTO CURSOR CURPAT
Previous
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