Re: what if integer is not integer - Informix SE on Linux
Hi, Francisco;
Following is the detail of trace log -
PREPARE WITH BIND VARIABLES:
update test set num =?
FLOAT Length0 ID? *250.0000000000000000* (4 MilliSeconds)
EXECUTE: (2 MilliSeconds)
GET AFFECTED ROWS: (0 MilliSeconds)
^ 1 Rows Affected
Randy
-----Original Message-----
From: Francisco Huezo <fhuezo@mh.gob.sv>
To: Randy Hao <rhao@sprynet.com>
Cc: informix-list@iiug.org <informix-list@iiug.org>
Date: Tuesday, April 06, 1999 5:28 PM
Subject: 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
>