General information
Category:
Coding, syntax & commands
Title:
How do you add fields to a database?
Back in the old FoxPro 2.6 times, I had a program which was able to add fields to any existing DBF; if the structure of the DBF wasn´t what the program wanted, it created a new file, appended everything from the old DBF, added indexes to the new file, deleted the old one, and renamed the new one (whew!).
Now... how do you do this when you use database containers (DBCs)? If you change just the DBFs, the DBC doesn´t change; if you bring over a new DBC, VFP protests that the DBFs do not match. The standard GENDBC program is great for creating a DBC and its DBFs for the first time, but it doesn´t work when they already exist.
When I add new functions to existing systems, sometimes I must add new fields to existing DBFs. My goal is to be able to give an user a program and tell him "Run such-or-such and all your tables will be updated".
Any ideas?
Thanks!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only