On Thu, Dec 27, 2012 at 7:27 AM, John Fabiani <johnf@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 value (int).
>
> But it never completes. This has to be some sort of bug. Anyone have a
> thought what would cause this to occur. To my knowledge it was working and
> does work in other databases.
There are many reasons this may or may not be working. Can you create
a self-contained test case that reproduces this issue?
