Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Programmatically Loading Field Comments into DBC tables
Message
De
14/02/1999 23:54:41
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Programmatically Loading Field Comments into DBC tables
Divers
Thread ID:
00187588
Message ID:
00187588
Vues:
78
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform