Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL, AS/400 and view parameters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00116137
Message ID:
00116153
Vues:
21
>You created remote views and opened them with NoDataOnLoad, then you specified your paramaters as private variables and issued a REQUERY() and got an error. When you run the same SQL with single quotes instead on double it works.

You're correct except the remote view is creating the SQL and I'm not getting an error, just no matching data. In debug the value of vp_cChar4 is "MB" not 'MB'.

>Are you using the LIKE instead of = in your WHERE condition and adding a % sign at the end of your view parameter?

I've tried LIKE but the % is unknown to me. Where does the % sign go?

TIA,
Rex
Rex A. Willis MCSD
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform