>>>>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