Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Matching Fields with Tables using .dbc
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00649793
Message ID:
00649810
Vues:
20
>I am attempting to create a cursor, using my database's .dbc table, that will match all Field
>objectnames with its corresponding Table objectname. I know this is done somehow by pairing the Field
>object's ParentId with its matching Table ObjectId, but how, I'm not sure. Thanks.

Is this what you're looking for?
SELECT ttField.ObjectId, ttField.ParentId, ttTable.ObjectName as TableName, ;
   ttField.ObjectName AS FieldName ;
   FROM tastrade.dbc ttTable ;
      JOIN tastrade.dbc ttField ON ttField.ParentId = ttTable.ObjectId ;
   WHERE ttTable.objecttype = "Table" ;
     AND ttField.ObjectType = "Field" ;
   ORDER BY tableName, fieldName
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform