There is not enough disk space for "name" (Error 56) at line
insert into curFinalResult from memvar

>Mohammed,
>
>Add ; before INTO cursor line.
>
>
>>thank you,
>>erro message
>>Unrecognized command verb
>> INTO cursor TAliascursor1 nofilter
>>
>>>>thank you,
>>>>i have no idea for that
>>>>>I see. In this case I suggest to forget about doing it using select and use procedural code to generate needed number of entries.
>>>>>
>>>>>>sorry for that, but still
>>>>>>File "name" is too large (Error 1190)
>>>>>>>You're missing FROM , e.g.
>>>>>>>

>>>>>>>select Numbers.Number, X.* from Numbers ;
>>>>>>>INNER JOIN (...) X ;
>>>>>>>ON ...

>>>>>>>
>>>
>>>

>>>SELECT  TAlias1.no,TAlias1.column3,TAlias1.sum1,TAlias1.total,TAlias2.ncount;
>>>              FROM a1 TAlias1, mas TAlias2 ;
>>>       WHERE  TAlias1.column3= TAlias2.column3 ;
>>>        INTO cursor TAliascursor1 nofilter
>>>
>>>select * from tAliasCursor1 where 1= 0 into curFinalResult readwrite
>>>
>>>select tAliasCursor1
>>>scan
>>> scatter memvar
>>>  for i=1 to nCount
>>>     insert into curFinalResult from memvar
>>>  next
>>>endscan
>>>
>>>select curFinalResult
>>>browse