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