[progress Communities] [progress Openedge Abl] Forum Post: Re: How To Avoid Duplicated Records

[caylali]

Hi Siddeshwar, Thanks for your response. I have set up a trigger to create a merchant record when the merchant name is not exist yet. I used your code ,but it always returns false no matter whether "x" is in "Merchant" or not. var count=rbv_api.selectQuery("SELECT count(*) FROM Merchant where name='x'", 1); if(count[0][0]>0){ return false; } else return true;

Continue reading...