New to Infosteward. Need assistance with Syntax.

[system]

I struggle with the syntax too.

See here for one of my previous posts with working syntax that may help you:-

120×120 10.4 KB

Hi All, I’m trying to create a Data Insightrule that checks to see how many times a vendor number exists in a table. Here’s my syntax:- BEGIN IF (SQL(‘RETAIL_LOOKUP_TABLES_BO4’, ‘select count(v_lev_levnr) from lookup_vendor where v_lev_levnr = $V_LEV_LEVNR’) > 1) RETURN FALSE; ELSE RETURN TRUE; END This validates successfully but when I test the rule with a non unique vendor number I get the message:-'Dataservices execution failed for (14.0) 08-29-12 09:52:45 (E) (22408:16524) DBS-070401:…

---

Nemesis (BOB member since 2004-06-09)