why when i do that
some field are empty in my new table but in my old table it has something ???

SELECT MyOldTable
SCAN
SCATTER NAME oTest
INSERT INTO MyNewTable FROM NAME oTest
ENDSCAN