Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically Loading Field Comments into DBC tables
Message
From
14/02/1999 23:54:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Programmatically Loading Field Comments into DBC tables
Miscellaneous
Thread ID:
00187588
Message ID:
00187588
Views:
80
Geetings Everyone!

I am in the process of creating tables in a DBC from a matrix whose structure is very similar to what you get when you do a Copy Structure Extended. In addition to those fields this matrix also contains field descriptions in a non-binary memo field. I did not see any way to load this description data using the Create MyTable1 Database MyDBC From MyMatrixTable technique.

I noticed that the Field Comments from the VFP Table Designer form are stored in the DBC's Proprty field. So, I wondered if I could match up MyMatrixTable.Field_Name with MyDBC.ObjectName and replace MyDBC.Property with MyMatrixTable.Description. So far I have been unsuccessful. MyDBC.ObjectName is a binary memo field and the Table Designer apparently stores other information in Property besides the Field Comments. All I ended up doing was corrupting the Property field in the DBC. (No damage done. I made a backup copy. And, this is not a production DBC, yet.)

Before I resign myself to the copy/paste one field at a time technique, I thought I would ask if any of you has ever done what I am trying to do. If so, how did you do it?

TIA and KR (Kind Regards)
William E. Kepner,
Senior Programmer/Analyst
M & S Consulting Services, Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform