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)