>>select distinct session_nu from (thisform.text1.value) into array aSession >>for x=1 to alen(aSession) >> * cCount=aSession(x) >> p_count=aSession(x) >> file_name="session_nu"+alltrim(cSession)&&& itry it as aSession >> select * from (thisform.text1.value) where VAL(session_nu)=p_count into table(file_name) >> >>endfor >> >>>>>Check for typos. And check that the first select really finds any records.
>>>>select distinct session_nu from (thisform.text1.value) into array ASESSION >>>>for x=1 to alen(aSession) >>>> cCount=aSession(x)&& "x" is not an array >>>> file_name="session_nu"+alltrim(cSession) >>>> select * from (thisform.text1.value) where session_nu=cCount into table (file_name) >>>>endfor >>>> >>>>>>>>
>>>>>cSession=str(p_count,2) && if session_nu is C(2) >>>>>select * from (thisform.text1.value) where session_nu=cSession into table (file_name)>>>>>Also check whether session_nu is left justified or not. If the value for example is '4 ' in stead of ' 4', you must use
>>>>>cSession=oadr(p_count,2) && if session_nu is C(2) >>>>>select * from (thisform.text1.value) where session_nu=cSession into table (file_name)>>>>>
>>>>>select distinct session_nu from (thisform.text1.value) into array aSession >>>>>for x=1 to alen(aSession) >>>>> cCount=aSession(x) >>>>> file_name="session_nu"+alltrim(cSession) >>>>> select * from (thisform.text1.value) where session_nu=cCount into table (file_name) >>>>>endfor>>>>>>thank you,
>>>>>>>>thisform.text1.Value=GETFILE("dbf") >>>>>>>>for p_count=1 to 4 >>>>>>>>file_name="session_nu"+alltrim(str(p_count)) >>>>>>>>select * from (thisform.text1.value) where session_nu=p_count into table (file_name)&&Operator/operand type mismat >>>>>>>>next >>>>>>>> >>>>>>>>>>>>>>>>thanks