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

If you look at an article on my website under Q&A, General, qGEN012 you can see some code that manipulates the DBC fields.

>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?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform