Visual Foxpro Modifing a field name

[Martylb]

In Visual Foxpro how can you change the name of field in a program. What will the command look like, I know what the new field name will be.
Example;
Store to Storeid
Change to field name in a program.

 

[baltman]

alter table TblName rename column OldName to NewName

There are a set of alter table commands... check the help.

Brian

 

[gchandrujs]

Hi Martylb

you can use the below sql statement for what you need

alter table tablename rename column colname to newcolname


HTH

gchandrujs

 

[Martylb]

I have a folder with the following tables in it
TRS1230 TRS1227 TRS1220
File4428 File4559 File5249
In Visual Foxpro how do I append all the tables which start with File into one file
So three files will be append into a new table

Martylb

 

[ramani]

HI


nFiles = ADIR(aFiles,"File*.dbf&quot

FOR i = 1 TO nFiles
cFile = aFiles(i,1)
IF I=1
USE (cFile)
COPY STRU TO myFile
USE myFile
ENDIF
APPEND FROM &cFile
ENDFOR

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com