on 02-05-2019 11:21 PM
Prompt: <SQL Query> where RISK_BU in (@prompt ('Select Business Units:', 'A','Risk\Business Unit',multi,free,persistent,{'Challenger'}))
Error: The following database error occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )
Details: If user upon running the report select a single value (even if the 4th parameter of prompt says multi) it works fine. If user selects multiple values (which it is meant to work) it throws the above error. I could not find any knowledge base article after hours of digging. Any help on this is highly appreciated.
Hi Susan,
It seems SAP KBA 2303826 - Error "[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near “,”.. ... is describing the same issue. You can take a look into it.
Cause: No need to put parentheses around the prompt definition. When running the query, the system will add those parentheses automatically.
Resolution: Eliminate the parenthese around the prompt definition :
Example:
select customer.country from customer
where customer.country in @prompt('Buyer (O):','A',,Multi,Free,,,)
Thanks,
Tuncay Karaca
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.