Página 1 de 1

TDbfBrowse - displays wrong decimal values

Publicado: Lun Abr 25, 2022 6:39 am
por Hurricane
Hi,

Note:
FIELD N, 12, 2
DBF Explore displays correctly
Xailer 7.2
xailer_dbfbrowse.png
xailer_dbfbrowse.png (37.57 KiB) Visto 808 veces
regards,

Re: TDbfBrowse - displays wrong decimal values

Publicado: Lun Abr 25, 2022 5:15 pm
por ignacio
Hi,

This is a known drawback of using databases other than DBFs. The solution is simple. You just have to set the cPicture property of the column.

Regards,

Re: TDbfBrowse - displays wrong decimal values

Publicado: Lun Abr 25, 2022 6:12 pm
por Hurricane
Please, correct the column class or setdbf (it's an inappropriate problem).
All other mechanisms/tools are displayed correctly, from a simple browse in Clipper (ugly for the Xailer tool).
Sometimes we just want to show, using setdbf we don't need to create and set the columns
ignacio escribió: Lun Abr 25, 2022 5:15 pm This is a known drawback of using databases other than DBFs. The solution is simple. You just have to set the cPicture property of the column.

Re: TDbfBrowse - displays wrong decimal values

Publicado: Mar Abr 26, 2022 4:20 pm
por ignacio
SQLite editor works correctly. Here is the code:

Código: Seleccionar todo

   WITH OBJECT oCol:oDataField
     IF :cType = "N"
        oCol:cPicture := Right( Replicate( "9", :nSQLLen ) + IIF( nSQLDec == 0, "", "." + Replicate( "9", :nSQLDec ) ), :nSQLLen )
     ENDIF
   END WITH
Regards

Re: TDbfBrowse - displays wrong decimal values

Publicado: Mar Abr 26, 2022 8:44 pm
por Hurricane
this is another BUG I'm reporting in browse.
I think the right thing is for you to correct it (but predicting that there will be programmer columns and no mask).

The other BUG, you simply asked me to use another Browse.
Another feature (freeze) said it would be in the next version, when I went to check it out, it said it wouldn't, then made an example using the same feature I did...

...I'm sorry, but you need to be more consistent.
ignacio escribió: Mar Abr 26, 2022 4:20 pm SQLite editor works correctly. Here is the code:

Código: Seleccionar todo

   WITH OBJECT oCol:oDataField
     IF :cType = "N"
        oCol:cPicture := Right( Replicate( "9", :nSQLLen ) + IIF( nSQLDec == 0, "", "." + Replicate( "9", :nSQLDec ) ), :nSQLLen )
     ENDIF
   END WITH
Regards

Re: TDbfBrowse - displays wrong decimal values

Publicado: Mié Abr 27, 2022 9:54 am
por ignacio
Thread ended.

Regards,