[SQL] strange corruption?

2012-12-27 Thread John Fabiani
Hi, I have the following statement in a function. UPDATE orderseq SET orderseq_number = (orderseq_number + 1) WHERE (orderseq_name='InvcNumber'); All it does is update a single record by incrementing a value (int). But it never completes. This has to be some sort of bug. Anyone ha

Re: [SQL] strange corruption?

2012-12-27 Thread Scott Marlowe
On Thu, Dec 27, 2012 at 7:27 AM, John Fabiani wrote: > Hi, > I have the following statement in a function. > > UPDATE orderseq > SET orderseq_number = (orderseq_number + 1) > WHERE (orderseq_name='InvcNumber'); > > All it does is update a single record by incrementing a value (int). >

Re: [SQL] strange corruption?

2012-12-27 Thread msi77
Hi, Maybe you have triggers on the target table. 27.12.2012, 18:28, "John Fabiani" : > Hi, > I have the following statement in a function. > >  UPDATE orderseq >  SET orderseq_number = (orderseq_number + 1) >  WHERE (orderseq_name='InvcNumber'); > > All it does is update a single recor

Re: [SQL] strange corruption?

2012-12-27 Thread Gavin Flower
On 28/12/12 03:27, John Fabiani wrote: Hi, I have the following statement in a function. UPDATE orderseq SET orderseq_number = (orderseq_number + 1) WHERE (orderseq_name='InvcNumber'); All it does is update a single record by incrementing a value (int). But it never completes. Thi

Re: [SQL] strange corruption?

2012-12-27 Thread Gavin Flower
On 28/12/12 05:44, John Fabiani wrote: On 12/27/2012 08:21 AM, Gavin Flower wrote: On 28/12/12 03:27, John Fabiani wrote: Hi, I have the following statement in a function. UPDATE orderseq SET orderseq_number = (orderseq_number + 1) WHERE (orderseq_name='InvcNumber'); All it does i