I'm running Spotfire Analyst 7.11 in conjunction with a Postgresql server version 10. I have made a Function in Postgres and used it to create a Procedure in Spotfire, as shown below:
create or replace function ins_aloc (char pre, char ref, char mat, timestamp without time zone aloc, char grav, char uf) returns boolean as $$ declare counter integer; Begin select count(*) into counter from public.pac t1 where t1.pre = $1 and t1.ref = $2; if counter > 0 then return false; else insert into pac (pre, ref, mat, aloc, grav, uf) values($1, $2, $3, $4, $5, $6); return true; end if; end; $$ language 'sql';
I would like to be able to get the procedure results (True or False) and insert into a Document.Properties. I will use this DP to show a message to the user about the insertion result (succeed or Failed).
I have been trying to get the result but I didn't realize how to do that. Thanks in advance.