>i do a select from a table and i want to copy each line to another table with the same structure. i want to copy it line per line
>
>
>how can i do it ???
>
>
>thanks
Why line per line?
INSERT INTO MyNewTable (field list);
SELECT (field list) FROm MyTable WHERE ....
If you realy need to do this line per line
SELECT MyOldTable
SCAN
SCATTER NAME oTest
INSERT INTO MyNewTable FROM NAME oTest
ENDSCAN
See also GATHER command in Help
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.