Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No table names, Please!
Message
De
27/01/2004 13:25:24
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00869464
Message ID:
00871048
Vues:
22
This message has been marked as the solution to the initial question of the thread.
>Unfortunately ... there's nothing you can do to enable that option. I reported it as a bug a while back but it hasn't been fixed. You just have to strip out the table names for every field.
>
>Sorry!
>Cathy
>
>
>>I am using Vfp v8.0 SP1 and do not know how to suppress table names from the expression builder and drag and drop from the data environment. The radio button is dimmed and not available in the expression builder.

The _getexpr system variable can be set to point to your .prg, and I was doing similar tricks already. For Glenn's case, something like this:
* _getexpr points to this little .prg, save it
lcSaveGetEx=_getexpr
* set it to point to default VFP expression builder
_getexpr=""
getexpr to lcTemp
* clean the current alias from the expression, keep other aliases
lcTemp=strtran(lcTemp, alias()+".", "",-1, -1, 1)
* restore for next call
_getexpr=lcSaveGetEx
return lcTemp
I've written a few little prgs like this, and in some cases the purpose was to see the dataenvironment while editing a report. The trick was to set the datasession before the GETEXPR command, and to restore it afterwards, so the expression builder would see all the tables. I used to store it in a custom property of _screen, as soon as I had all the cursors ready, Set Datasession to _screen.nds, GETEXPR, Set Datasession to nSaveDS. Worked perfectly.

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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform