Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Agent to Delete Records

Status
Not open for further replies.
Dec 27, 2002
167
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top