Hi there,
it seems to be a problem to catch errors on SDI-SQL?
CREATE or replace PROCEDURE test --IN NAME NVARCHAR(1000)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
BEGIN
DECLARE s nvarchar(1000);
DECLARE CONTINUE HANDLER FOR SQLEX...
Hi,
am I right that using a built-library is not avalilable in a trigger procedure? I tried to use the simple SQLSCRIPT_STRING library.
Code
TRIGGER "MyTestProject.db.Trigger::Table_INSERT" AFTER INSERT ON "MyTestProject.db.Tables::TARGET_Table...
Thank you! Yet another workaround. Seems to be more expensive than doing the split manually with substring and locate in my case, though. But a working idea!