TDbfBrowse - displays wrong decimal values

[Hurricane]

Hi,

Note:
FIELD N, 12, 2
DBF Explore displays correctly
Xailer 7.2

xailer_dbfbrowse.png (37.57 KiB) Visto 1210 veces

regards,

[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,

[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

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.

[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

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

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

[ignacio]

Thread ended.

Regards,