I am trying to do a select statement using this INLIST(), It doesn't seems to work.
for i = 1 to thisform.selectedlist.listcount
if i < 2 then
SQL_String = alltrim(thisform.selectedlist.ListItem(i))
else
SQL_String = SQL_String + "," + alltrim(thisform.selectedlist.ListItem(i))
endif
endfor
select all a.cid, a.cname, b.csemester, b.ccourse, b.ccouroff, b.cstudent from sys_mast a, enroll b where a.cid = b.cstudent and INLIST(rtrim(b.csemester), SQL_String) into dbf c:\attend\temp
when I brows the temp table it is empty.
thank you for any help.