In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

TDbfBrowse - displays wrong decimal values

Xailer professional forum in English
Cerrado
Avatar de Usuario
Hurricane
Mensajes: 262
Registrado: Mar Mar 24, 2015 10:21 am
Ubicación: Brasil
Contactar:

TDbfBrowse - displays wrong decimal values

Mensaje 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 739 veces
regards,
Adjuntos
brwColDec_X72.zip
(2.97 KiB) Descargado 51 veces
Developments | Trainings | Projects
Site | E-mail | Messenger | YouTube
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9246
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Re: TDbfBrowse - displays wrong decimal values

Mensaje 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,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Avatar de Usuario
Hurricane
Mensajes: 262
Registrado: Mar Mar 24, 2015 10:21 am
Ubicación: Brasil
Contactar:

Re: TDbfBrowse - displays wrong decimal values

Mensaje 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.
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9246
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Re: TDbfBrowse - displays wrong decimal values

Mensaje 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
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Avatar de Usuario
Hurricane
Mensajes: 262
Registrado: Mar Mar 24, 2015 10:21 am
Ubicación: Brasil
Contactar:

Re: TDbfBrowse - displays wrong decimal values

Mensaje 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
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9246
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Re: TDbfBrowse - displays wrong decimal values

Mensaje por ignacio »

Thread ended.

Regards,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Cerrado