[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

Re: [SQL] strange corruption?

2012-12-27 Thread Scott Marlowe
On Thu, Dec 27, 2012 at 7:27 AM, John Fabiani jo...@jfcomputer.com 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

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 jo...@jfcomputer.com: 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

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.

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