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)To check for the different values for session_nu, you can select all the values into an array
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