Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing Arbitrary Conditions to Parameterised Views
Message
From
22/03/2004 12:17:34
 
 
To
22/03/2004 01:33:05
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00888275
Message ID:
00888566
Views:
14
Greetings Dorin

I'd actually tried your suggestion a variant (&?qrycode) suggested by Sergey in another thread. Apparently it works under vfp7 sp1 but not vfp8 sp1


>Hi
>I remember something about using macrosubstitution instead parameters.
>
SELECT Contacts.*;
> FROM ;
>     CONTACT!CONTACTS;
> WHERE &qrycode
>
>The qrycode variable must exists at design times, otherwise wil be includes as is, and the SQL command will fail.
Previous
Reply
Map
View

Click here to load this message in the networking platform