I have my tables and programs in different directories with fullpath off and doing the same stuff below it put the new table in the program directory where I have SET DEFA TO.

Charles

>Hi all,
>
>Since FPD doesn't have an ALTER TABLE command I had to do the following:
>
>1) x = DBF()
>
>2) Create temp file with a modified structure for x and append data.
>
>3) COPY TO (x)
>
>Because I don't have FULLPATH on, DBF() returned E:FileX.dbf instead of E:\Somepath\FileX.dbf.
>
>At my site, x will now have the new structure, but at customer it didn't!! I suspect that in his environment the COPY TO (x) copied to a different place.
>
>Monday I will know for sure, but can anybody confirm or deny this?
>
>TIA,
>
>Alex