>>Although most of the others recommend textmerge, I wouldn't bother in this case where name subsitution is enough. I find it much easier to read code that contains the actual SQL command than code that builds a string and executes it. While I haven't tested, I see no reason why this version would be slower.
>>
>>Tamar
>
>Oh I was feeling alone:) Thanks.
>Cetin
Cetin,
You posted correct solution, but Tamar made a mistake.
SELECT (laTmp[1]) AS (lcNewField) ;
> FROM (lcOldFile) ;
> INTO TABLE lcNewFile DATABASE (lcTableDBC)
If it's not broken, fix it until it is.
My Blog