Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there any way to browse a table without field caption
Message
De
31/08/1998 10:06:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
31/08/1998 00:37:27
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00129442
Message ID:
00131509
Vues:
15
>>>I'd like to browse a table and be able to read the actual field name on the column header instead of the caption from the database. Any ideas?
>>>
>>>
>>>Thanks,
>>>
>>>Gil
>>Use a grid control or a view.
>>Cetin
>If you want to browse from a command box you could create a utility program. Perhaps something like
>
>*BROWSE_NC
>PARAMETERS tablename
>SELECT (tablename)
>
>STORE "BROW FIELD " TO browse_string
>FOR I=1 TO FCOUNT()
>STORE browse_string+ "(FIELD(" +ALLTRIM(STR(I))+ "):H=FIELD(" +ALLTRIM(STR(I))+")"
>ENDFOR
>&browse_string
>RETURN
>
>Then call "BROWSE_NC(yourtable)" from the command box.
>(Of course this would be limited to the max macro string length)
Larry,
Too much work. This one is for just seeing fieldnames while browsing. So only "select * from mytable where .t." would be enough if you hate "on key label" (see my other reply).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform