Then I don't know what causes this error. Anyway, I hope I have given you some hints so that you will solve your problem.

>hi ,
>thank you ,
>only one field have the same name as sission_nu, also same error.
>
>anyway thanks again.
>
>
>>Try to replace some of the variable names, maybe they collide with your field names.
>>
>>>hi,
>>>sorry to bother you,
>>>but i try as under same error,
>>>

>>>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.
>>>>
>>>>>hi,
>>>>>thank you very much,
>>>>>i try it i get error message "x" is not an array
>>>>>

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

>>>>>
>>>>>>If session_nu is character, you should be able to use val(session_nu). But it is better to compare character values directly.

>>>>>>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,
>>>>>>>Most likely session_nu is not numeric. yes ,(session_nu) charatcter type.
>>>>>>>i try as val(session_nu)....error .
>>>>>>>
>>>>>>>thank you for file_name="session_nu"+transform(p_count).
>>>>>>>
>>>>>>>mytable have different session_nu every time,
>>>>>>>for p_count=1 to 4,5,3 or 10...etc,
>>>>>>>is there away to count session_nu to variable as
>>>>>>>
>>>>>>>for p_count=1 to m.e
>>>>>>>thanks
>>>>>>>
>>>>>>>
>>>>>>>>>hi all,
>>>>>>>>>
>>>>>>>>>i try via this code under i get erroe message Operator/operand type mismatch
>>>>>>>>>

>>>>>>>>>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
>>>>>>>>
>>>>>>>>Most likely session_nu is not numeric. And by the way, you can simplify the line file_name="session_nu"+alltrim(str(p_count)) to file_name="session_nu"+transform(p_count). And add a space between table and (file_name)