Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
add new field ???
- Thread starter lminmei
- Start date
infinitelo
Programmer
- Mar 7, 2001
- 319
yes, to add a column you query the dbf to a temp space with the added column, then copy the query results back to the original file location.
CAUTION!!! I did not look up the syntax on this one,
but this should get you started.
if your dbf is
firstname char 20
lastname char 30
your query could be
select firstname,lastname,fistname&' '&lastname into c:\mytemp\newfile from c:\mytemp\oldfile
run copy c:\mytemp\newfile c:\mytemp\oldfile
if it is to be it's up to me
CAUTION!!! I did not look up the syntax on this one,
but this should get you started.
if your dbf is
firstname char 20
lastname char 30
your query could be
select firstname,lastname,fistname&' '&lastname into c:\mytemp\newfile from c:\mytemp\oldfile
run copy c:\mytemp\newfile c:\mytemp\oldfile
if it is to be it's up to me
- Status
Similar threads
