Hi People, How can I transform the Mendix sql Query: 'Select attr1,attr2,attr3,attr4 from TABLEAU where attr1 = “'+$Search/PID+'”;' to a valid oracle sql Query: Select attr1,attr2,attr3,attr4 from TABLEAU where attr1 = '206298'; Specialy, how can I insert quotes like ‘$Search/PID’ I Got an error: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Many thanks
asked
Abdessamad Abba
1 answers
2
Oracle wants single quotes in the WHERE attr1 = '1234'. So try this:
'Select attr1,attr2,attr3,attr4 from TABLEAU where attr1 = '''+$Search/PID+''';'