Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized view
Message
 
À
23/08/1999 09:27:23
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00256536
Message ID:
00256558
Vues:
21
>>I have created a view that asks the user to enter a Fiscal Year, e.g.
>>
>>prcFiscalYear LIKE ?'Fiscal Year Surrounded by % (e.g. %98%)'
>>
>>The view when used comes up and asks the appropriate question, but my user does not want to enter the %, they just wish to enter the 98. So how can I have a parameter that comes up with a question, but after the user enters the fiscal year slaps a '%' on the front and back of what they entered. Any help would be appreciated. Or send me in another direction on getting user input in a parameterized view.
>
>prcFiscalYear LIKE "%"+?'FiscalYear Please'+"%"
>Cetin

Thanks Cetin you led me in the right direction I used what was above, but when entering the fiscal year 99 or 98 it was being interpreted as a numeric, so I changed it to:

prcFiscalYear LIKE "%"+ALLTRIM(STR(?'Fiscal Year (e.g. 97,98,..)'))+"%"

And now it works like a charm.
Thanks again.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform