Question Kaveh Kaviani · Oct 30 dynamic SQL in object script code i am trying to embed a dynamic SQL into Objectscript code , but the %NEXT() will return 0 , however when i copy the same query and run it in the SQL bit it will give me the result i want the code : #ObjectScript #SQL #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 0 2 0 69
Question Kurro Lopez · Oct 18 How to get the native sql error in SQL outbound adapter? Hi all, We have an restriction in a SQL database with a unique index. We want to catch that exception when it tries to insert or update a value that violates the unique index condition. #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 3 0 47