Re: Creating Decrementing value in Table

Hi All, Thanks for all your help i have managed to do now the incrementing in the table as well as decrementing it. Regards, Amey On 12/30/08, ccrashh ccra...@gmail.com wrote: Why would there be a perfomance impact? How are you adding this new record? You already know that the highest

Re: Creating Decrementing value in Table

Why would there be a perfomance impact? How are you adding this new record? You already know that the highest value is 5, so when you add a new record (in your example called Test6) that the new Order ID would be the current max order id + 1. So when you do a Push Fields to create a new record,

Re: Creating Decrementing value in Table

I think the easiest approach is, as Mike said, an Update SQL statement: UPDATE childtablename SET counter = counter - 1 WHERE parentrequestid = '$request_id$' AND counter '$counterbeingdeleted$' childtablename = the schema of the child form counter = field on the childtablename that stores the

Re: Creating Decrementing value in Table

One more request.i was earlier able to increment the counter in the table but having issues in performance now .so would you be able to guide me in how to implement the Increment value in Table same as to one you have given me for Decrementing. Acutal Scenario is that when user

Re: Creating Decrementing value in Table

In a message dated 24/12/2008 18:09:05 GMT Standard Time, ameyb...@gmail.com writes: amey.x.bhos...@jpmorgan.com Hi Amey, Using an SQL statement will provide the fastest possible solution. I'll send you the details. Kind regards Mike

Creating Decrementing value in Table

Hi All,   I am currently working on ARS 7.1 and have a query to ask you all.   I have created a Regular Form on which i have added a table field(holding data into anothe form) which displays only those records which have a flag set to Yes   On this Regular Form i have added a Add/Modify  and

Re: Creating Decrementing value in Table

, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amey Bhosale Sent: Wednesday, December 24, 2008 10:21 AM To: arslist@ARSLIST.ORG Subject: Creating Decrementing value in Table ** Hi All, I am currently working

Re: Creating Decrementing value in Table

You could use a single SQL statement in an Active Link to update records to order_id -1, where the order_id than that for the record just deleted. Just add an integer display only field 'zTmpCurOrderId' which is set to the order_id for the current record about to be deleted. Use this

Re: Creating Decrementing value in Table

Hi Mike, Can you tell me whether writing SQL statement will it affect the performance of checking each record and then updating it? Also would you be able to send me the code at amey.x.bhos...@jpmorgan.com id so that i can check and test the same? Regards Amey On Wed, Dec 24, 2008 at 10:20

Re: Creating Decrementing value in Table

. Thanks, Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amey Bhosale Sent: Wednesday, December 24, 2008 10:21 AM To: arslist@ARSLIST.ORG Subject: Creating Decrementing value in Table ** Hi All, I am

Re: Creating Decrementing value in Table

) [mailto:arsl...@arslist.org] On Behalf Of AMEY BHOSALE Sent: Wednesday, December 24, 2008 12:18 PM To: arslist@ARSLIST.ORG Subject: Re: Creating Decrementing value in Table Hi Opela, Thanks for the response. On Delete Button i have set an AL which set the record status to No which