Re: what if integer is not integer - Informix SE on Linux

I didn't understand well, but could you try to configure the disablebind=1 and set dbtrace with ON at its profile database connection, that's way, powerbuilder will write down the pbtrace.log in %SystemRoot% directory and you can open and come over it what statements, powerbuilder, sent to informix database server. I'd like to do one question. Why do you use no datawindow to uptade the table? And second, when you used dw_1.retrieve(50), powerbuilder sends the 50 as the first argument of dw_1 and returns a long with value of the count rows retrieved or > 0 when there is a error. You could use the sqlsyntax event in dw_1 to inspect what powerbuilder sents to databases (I hope to understand me because I don't speak english well) Randy Hao wrote: > I have PB6.0 running on Win95 and Win98 machine. They are connected to > Informix SE on Linux box by using native driver from PB6 with Informix > I-Connect 7.2, and I found I can not keep the same integer value in PB and > Informix > > 1) If I run the following code: > > long ll_test > ll_test = 250 > update test_table set col1 = :ll_test;> > the col1 value in Informix table test_table will be 249 ( if col1 is integer > field ) or 249.9999999999999000 ( if col1 is char(20) ). > > 2) If I use retrieve() function in PB6: > > dw_1.Retrieve(50) returns the value like parameter of 49. > > Is it floating bug or floating setting problem? If it is the setting > problem, where I can change the settings? > > Thanks you very much for any feedback. > > Randy