Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing Arbitrary Conditions to Parameterised Views
Message
De
22/03/2004 12:17:34
 
 
À
22/03/2004 01:33:05
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00888275
Message ID:
00888566
Vues:
15
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform