Hi Renoir,
I didn'n read whole the tread but why you not try:
SELECT MyFile
SCATTER NAME oScatt
SELECT OtherTable
INSERT INTO OtherTable (FirstField) VALUES (SomeValue)
GETHER FROM oScatt
HTH
Boris
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.