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
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,
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
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
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
I'm assuming that whenever you 'delete' a record, you are simply changing the
status so that it doesn't show up on the table, then refreshing the table.
You could add a filter that runs on the child form, the one from which the
table is pulling its data, and have that filter run whenever the
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
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
Hi Opela,
Thanks for the response.
On Delete Button i have set an AL which set the record status to No
which was initially Yes and hence the record will no longer appear in
the Table as the qualification of table is to display only those
records which are Yes.So now this record will still
)
[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
10 matches
Mail list logo