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.