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 PM, <arlist...@aol.com> wrote: > ** > > 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 value > in the SQL statement. > > The table refreshes correctly and the order_id's get updated as expected. > Can send you the code off-line if it helps? > > I trust this is of some help. > > Kind regards > Mike > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"