Sweetworks
MIS
I am trying to create an Agent. If it was in SQL I would write Delete * from Contact where CompanyUnique = “XXXX”. Do you know how one would write that in Notes?
Furhtermore Based on above. IF say the syntax was what I had for the SQL example, how would I separate them to say put 1000+ entries in the same Agent?
For Example
Delete * from Contact where CompanyUnique = “XXXX1”;
Delete * from Contact where CompanyUnique = “XXXX2”;
Delete * from Contact where CompanyUnique = “XXXX3”;
etc
Furhtermore Based on above. IF say the syntax was what I had for the SQL example, how would I separate them to say put 1000+ entries in the same Agent?
For Example
Delete * from Contact where CompanyUnique = “XXXX1”;
Delete * from Contact where CompanyUnique = “XXXX2”;
Delete * from Contact where CompanyUnique = “XXXX3”;
etc