on 03-11-2019 12:58 PM
Hi,
The $[$38.10002037] is distribution rule, when i provide the dist rule then query works correctly means and when i dont provide the dist rule norrmally it should allow to create the Purchase order. But it throwing the error as "Could not commit transaction: Error -1 detected during transaction" . i used the converter to convert my sql query to the below HANA query. is there any error in the query ?
SELECT DISTINCT 'TRUE' FROM DUMMY WHERE $[$38.10002037] IN ('100','110') AND NOT EXISTS (SELECT "CardCode" FROM "OCRD" WHERE "CardCode" = $[$4.0] AND "QryGroup13" = 'Y');
Dwarakanath
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.