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
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).
>
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
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
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