Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating views.
Message
De
16/05/2001 10:30:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Creating views.
Divers
Thread ID:
00507816
Message ID:
00507816
Vues:
46
Can you use variables when creating views?

I am testing the creation of a view. When I hard code the parameter for the the field pendcds as below:

create sql view tranhdr remote connection novtrans as SELECT * FROM tranhdr ;
WHERE pendcds = 'w16' and repaired = 0 AND valerror = 0

I have no problem, but when I pass a veriable, as below:

lcPendcds = "w16"
create sql view tranhdr remote connection novtrans as SELECT * FROM tranhdr ;
WHERE pendcds = &lcPendcds and repaired = 0 AND valerror = 0

I get an error stating that no filed named 'w16'.

Question how to get around this?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform