>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