Re: Binding with PowerBuilder

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