Problem with numeric fields and FWH 25.01

[vilian]

Hi Guys,
IF I run the code bellow with my previous version of FWH. I can see the value 3.3732. But if i run this same code with the new version of FWH, the value showed is 3.37. Do you know why ?

Code: Select all | Expand

function Main()
LOCAL oRs,oCn,oError,oQry,cQryMat

   SET DATE BRIT
   SET CENTURY ON
   
   CursorWait()

   oCn := Maria_Connect( aStr[1] )

   oRs := oCn:Query("SELECT nfiscal,cmat,qte,qtedig FROM consumo WHERE nfiscal LIKE '000005829%'")
   cQryMat := ""
   DO WHILE .NOT. oRs:Eof()
      cQryMat += "'"+oRs:cmat+"',"
      ? oRs:qte,oRs:qtedig,oRs:cmat
      oRs:Skip()
   ENDDO
   oRs:GoTop()
   
RETURN NIL

[Antonio Linares]

Dear Vilian,

Are you using SET DECIMALS TO 4 ?

[vilian]

Antonio,
No I'm not setting any value to SET DECIMAL. However, is important note that the problem is only happening with decimal values from Mysql rowset/queries. IF I try something like:

Code: Select all | Expand

function Main()
LOCAL nVal1,nVal2,nRes

   SET DATE BRIT
   SET CENTURY ON
   
   nVal1 := 2.3432
   nVal2 := 2.3923
   nRes := nVal1 * nVal2 
   ? nRes
   
RETURN NIL

Everything is fine.

[vilian]

The code Bellow:

Code: Select all | Expand

oRs := oCn:Query("SELECT nfiscal,cmat,qte,qtedig,valor FROM consumo WHERE nfiscal LIKE '00023332601%'")
? oRs:qte,oRs:valor,oRs:qte*oRs:valor

In FWH2311 shows this:


In FWH2501 shows this:

[vilian]

Any progress?

[Antonio Linares]

Dear Vilian,

What is previous FWH version that you were using ?

[vilian]

my previous version is FWH 23.11

[Antonio Linares]

Dear Vilian,

I need you to help me to build a small example that I can run here and that generates the error.

Mr. Rao continues at the hospital, so we have to fix it ourselves.

We need to identify the exact FWH version where such error started so we can review the source code diferences.

[vilian]

Dear Antonio,

IF you have any table in your mysql server where you have numeric fields with more than 2 decimals. Just run the code bellow and you'll see the problem.

Code: Select all | Expand

oRs := oCn:Query("SELECT nfiscal,cmat,qte,qtedig,valor FROM consumo WHERE nfiscal LIKE '00023332601%'")
? oRs:qte,oRs:valor,oRs:qte*oRs:valor

In my case QTE,QTEDIG and VALOR are numeric fields with more than 2 decimals

Mr Rao told me this:

1) Good morning your point about the numeric fields is correct This is an unfortunate bug I'll try to fix it as soon as I can

[Silvio.Falconi]

Dear Antonio,

IF you have any table in your mysql server where you have numeric fields with more than 2 decimals. Just run the code bellow and you'll see the problem.

Code: Select all | Expand

oRs := oCn:Query("SELECT nfiscal,cmat,qte,qtedig,valor FROM consumo WHERE nfiscal LIKE '00023332601%'")
? oRs:qte,oRs:valor,oRs:qte*oRs:valor

In my case QTE,QTEDIG and VALOR are numeric fields with more than 2 decimals

Mr Rao told me this:

1) Good morning your point about the numeric fields is correct This is an unfortunate bug I'll try to fix it as soon as I can

I try this


Perhaps you have a round number ?
can I have a small test to try , perhaps I try to search a solution

[vilian]

Silvio,
The problem is happening only with numeric fields from a rowset. With variables everything is ok, like i said before.

[Silvio.Falconi]

Then It Is AN error of mariadb ?

[vilian]

Yes.

[cnavarro]

Dear Vilian, structure table or type of this fields?, thanks

[vilian]

Dear Cristobal,

The type of the fields is:

QTE DECIMAL(11,3)
VALOR DECIMAL(12,4)