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