Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Roger Meyers — — source: Informix-list mailing list archive (1991-1998)
On Tue, 05 Aug 1997 14:30:51 -0500, Eric Fontaine
<eric_fontaine@administaff.com> wrote:
>I have what may be an interesting problem.
>
>I am a PowerBuilder programmer but don't know where else to turn with
>this issue...
>
>Our Informix DB returns an SQL -3 (row changed between retrieve and
>update) error when trying to perform an update. This occurs when a
>column has a numeric datatype and is less than .5.
>
>If I turn off binding with Informix, the update proceeds correctly and
>succesfully.
>
>PowerSoft insists that our Informix DB is mishandling the bind/bind
>variables and PowerBuilder is led to believe that another user has
>altered the data on the server since the last retrieval.
>
>Any ideas?
Hi Eric,
I experienced the same problem except with the date variable. I have
been running (in production) with Binding cut off (using the DBParm)
without any (known :) adverse effects... Have you considered this?
(My appl. doesn't tend to do the same SQL to a large number of rows).
Also, my ODBC (Openlink) vendor indicated that this might be their
problem... I am waiting to hear more.
HTH.
Roger Meyers
roger@stratsoft.com
Strategic Software Solutions
San Francisco...
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.