Re: [Info-ingres] sequence .nextval evaluating twice when used inside an INSERT cmd

At 2:42 PM +0100 7/22/05, morgan brickley wrote:
Call anyone spot the difference in the newsessionid value in these two examples ?

[snipped]

In the first the newsessionid being called twice whereas in the second it gets called once (the expected behaviour). It seems that if you use a sequence directly as a parameter it gets stepped twice. Not using it as a paramter directly solves the issue. 


I think I saw an R3 bug-fix for something like this very recently.
It wouldn't be in the current posted builds yet.

Karl
.

Relevant Pages

  • Re: OT: flashlights again
    ... Karl ... > wonder how one can say with any certainty when something is "twice as ... Reflector size and shape are ... > much more important in realizing a "good" flashlight. ...
    (rec.crafts.metalworking)
  • Re: Letter to Contact
    ... Russ Valentine [MVP-Outlook] "Karl T" wrote in message ... > A.N. Other Support ... > This is annoying as when we create a mail merge it shows the persons name twice. ...
    (microsoft.public.outlook.contacts)
  • Fix a problem
    ... new system to d/l or other such things. ... So I made /dev/sda12 twice as large and the used dd to put ... Karl F. Larsen, AKA K5DI ...
    (Ubuntu)
  • Re: mailing list pgp signatures...
    ... public as it should be' public Key each and every post. ... Does it twice. ... g reminds me a lot of Karl that used to be on here. ... I have a Ubuntu friend. ...
    (Fedora)
  • Re: Letter to Contact
    ... "Karl T" wrote: ... >> To learn about ways to control how an Address is inserted into Word from ... it opens word then inserts the following details. ... >> notice that the name appears twice ...
    (microsoft.public.outlook.contacts)