HI,
When we perform queries (select, delete, update) on a PostgreSQL database under Uniface, if the query returns nothing (0 for select, 0 for update, or 0 for delete), we get an error in the status return.
exemple:"ERROR=-3·;
MNEM=<UIOSERR_EXCEPTIONAL>·;
DESCRIPTION=I/O error·;
COMPONENT=B54R0022·;
PROCNAME=B00_SQL·;
TRIGGER=EXEC·;
LINE=45·;
PROCLINE=sql "%%$SQL$", "$def""
requete update:update b50_article set rds_update=COALESCE(rds_update,0)+1, rds_version=COALESCE(rds_version,0)+1,rds_site_update='C1',bf_ancien=bf,bf_ancien_ref=bf_ref,bf=(select bf from b50_article a where a.marq=b50_article.marq and a.codeart=replace(b50_article.codeart,'DUP1','')),bf_ref=(select bf_ref from b50_article a where a.marq=b50_article.marq and a.codeart=replace(b50_article.codeart,'DUP1','')),bf_date=(select bf_date from b50_article a where a.marq=b50_article.marq and a.codeart=replace(b50_article.codeart,'DUP1','')) where codeart like '%DUP1' and replace(b50_article.codeart,'DUP1','')=(select codeart from b50_article a where a.marq=b50_article.marq and a.codeart=replace(b50_article.codeart,'DUP1','') and a.codeart='06SA994798' and a.obsolete='F' and (a.bf<>b50_article.bf or a.bf_date<>b50_article.bf_date))
thank you
