Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Comment in Table Structure
Message
From
01/10/2000 22:32:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00423294
Message ID:
00423299
Views:
9
>Hi All!
>
>I have two DBCs that almost have exactly the same tables in it except for some. I've put some comment in every field of DBC1 and would like to just copy what i've done there in DBC1 to DBC2, most specially the field comment. I've thought about using the AFIELDS() function but it accomodates only the table comment, no field comment. How do I extract the information from the table's field comment, put it, say in an array, and then copy the information from it, and put it in another table..?

Take a look at the GENDBC.PRG program that comes with VFP. It generates a program that can programmatically create a .DBC:
OPEN DATABASE MyDataBase
DO GENDBC
Take a look at the code and modify appropriately.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform