Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to redirect output of a SQL select .....
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00025106
Message ID:
00025126
Views:
35
-- snip --
>Thanks for your kind reply.
>But still I have a problem.
>
>The default view parameter inquiry box always reads
>- enter a character value for+blank box -
>when I add '?' into the WHERE Clause.
>I'd like to change this message into my mother tongue.
>And it was the reason that I wrote the Question.
>Is there any way to change this message ?
>Or In case it's not possible,
>could you tell me some tips to make it without using a view.
>
>Rexall

I don't know if it's possible to change the language, but you can avoid having the message come up at all. Just make sure the variable cName is available when you load or requery the grid.

First, use a regular textbox (or other method you choose) to get the value for cName. A user can pick it from a listbox or grid, enter it into a textbox, etc. Make sure the variable is cName.

Second, requery the view. It will requery using the value for cName which you just assigned.

Third, display the view (form, grid, etc.)

If you have the view in your DataEnvironment, be sure the property NoDataOnLoad is .T., then assign your cName variable and requery.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform