Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View Question
Message
From
17/03/2004 07:39:44
 
 
To
16/03/2004 19:16:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00886913
Message ID:
00887018
Views:
9
Hi,

Have you defined your parameter as Character? You do this by going to Query / View Parameters and then type in the variable name and specify it as Character.

HTH
Dennis

>When I set up a SQL parameterized view, by adding ?variablename in the View Designer, I always have to enclose my repsonse in the pop-up text box with single quotes. Is there a way to have FoxPro automatically place the single quotes around the keyed response? I generally can remember to add the single qutoes when I'm entering data but most users are generally confused by this requirement and often forget.
>
>Thanks,
>Robert
Previous
Reply
Map
View

Click here to load this message in the networking platform