select distinct session_nu from (thisform.text1.value) into array aSew for x=1 to alen(aSew) cCount=aSew(x) ? cCount&&7 sessions file_name="session_nu"+alltrim(aSew(x)) select * from (thisform.text1.value) where session_nu=cCount into table (file_name) endfor >>hi,
>select distinct session_nu from (thisform.text1.value) into array aSew >for x=1 to alen(aSew) > cCount=aSew(x) > ? cCount&&7 sessions > file_name="session_nu"+alltrim(aSew) > select * from (thisform.text1.value) where session_nu=cCount into table (file_name) > >endfor >>
>>>>>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