You didn't specify what version of AR System you are using. I don't remember 
exactly which version included archiving , but if you have a version that 
supports archiving that is an easier way to accomplish this task. One of the 
options in the archive is to just delete the records.
 

>>> Ravikumar_Tadi <[EMAIL PROTECTED]> Mar 28, 2007 2:09 AM >>>
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"

Reply via email to