Hi All, I am using
Application-Delete-Entry "$SCHEMA$" $1$ On event Delete on "$SCHEMA$" I initiate, if necessary, a new delete is started in other forms. Regards, Daniel -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 28, 2007 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: Help On Deleting Record If you already have the EntryID you can use the Run Process command of Application-Delete-Entry "$SCHEMA$" $1$ If you are searching for records to delete (i.e. deleting child records in another form) put the qualification inside a set of parenthesis like this Application-Query-Delete-Entry "$SCHEMA$" ( 'Create Date' < ("$TIMESTAMP$" - 604800)) Think of the qualification as what you would put in the Advanced Search bar on the form and then just put () around it. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravikumar_Tadi Sent: Wednesday, March 28, 2007 3:09 AM To: arslist@ARSLIST.ORG Subject: Help On Deleting Record Hello Listers, I have a requirement to delete records which are 7 days old from a form i.e. FormA on every Saturday 9 AM. I have created an escalation in FormA with run if condition as 'Create Date' < ($TIMESTAMP$ - 604800) and in the if action I have created a run process action with the command as Application-Query-Delete-Entry "$SCHEMA$" $Create Date$ < ($TIMESTAMP$ - 604800) I also used the below command @: Application-Query-Delete-Entry "$SCHEMA$" $Create Date$ < ($TIMESTAMP$ - 604800) But the above command does'nt delete the matching records from FormA. Appreciate any help ASAP. Regards, Ravi Kumar T __20060125_______________________This posting was submitted with HTML in it___ DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"