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: [email protected]
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"

Reply via email to