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

Click here to load this message in the networking platform