Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable in SELECT command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00018551
Message ID:
00018555
Views:
30
>Anybody know the proper syntax for the following SELECT statement, where p_PayeeName is a public variable. As it is now, it isn't searching for the value of the variable.
>
>SELECT payee_code, payee_name;
> FROM wc!payee2;
> WHERE payee2.payee_name like '%p_PayeeName%';
> ORDER BY payee_name

May be I am wrong, but it should work:
SELECT .... WHERE payee2.payee_name like p_PayeeName ....
Check that you really 'see' the public variable.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform