General information
Category:
Coding, syntax & commands
>>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
>
>Try using a macro '&varname', varname='%p_payeename%'
Thanks for the help, but what's a macro? Where would I put this?
Jeff
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only