Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Maximum length fieldnames free tables 10 characters why?
Message
De
17/02/2005 23:59:37
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
17/02/2005 16:47:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8
Divers
Thread ID:
00988010
Message ID:
00988215
Vues:
38
>There's allways:
SELECT AReallyLongFieldName AS A, AReallyReallyLongFieldName AS B FROM MyTable ORDER BY A, B
:)

He can always do the opposite from this - create views (in a separate dbc) off these free tables, and in these views he can have all the long names he likes...
Create Sql View V_Whatever_and_ever As ;
	Select sd.subevmfk as SubEventMasterForeignKey, ;
	sd.subevdpk as SubeventDetailPrimaryKey, ;
	sd.rtfm as ReadTheFabulousManual, ;
	sd.gfdob as GrandFathersDayOfBirth ;
	FROM fretbl sd
The Gendbc generated source for these views can be all the documentation needed for the link between these shrtfldnm and VeryLongAndDescriptiveFieldNames.

Disclaimer: some of these short field names really exist. Some don't.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform