FiveTech Software tech support forums

Hi Mr Nages,

Any solution for the question for decimal point separator ....

thank you very much,

I intended the algorithm for integers. If you want to use values with 2 decimal places, then I suggest you make the array of Int( eachvalue * 100 ). Also, convert the target value to Int( nTarget * 100 ) After finding items, divide by 100 and show it to the ...

Con el ejemplo que enviaste, se conecta. oCn := FW_OpenAdoConnection( "MYSQL,208.91.198.197,fwhdemo,gnraofwh,Bharat@1950", .t. ) oRs := FW_OpenRecordSet( oCn, "SHOW COLUMNS FROM customer" ) XBROWSER oRs TITLE "customer table : columns" oRs:Close() muestra bien la estruc...

First, please clarify whether it worked with customer table on the Cloud server?

Depending on your answer, we can help you with your table on your own server.

... * from clientes" ) XBROWSER oRs oRs:Close() oCn:Close() return nil Tengo fwh1709, con xharbour7, mysql server 8.0 Tengo una tabla sin campos decimal y lee perfecto. Saludos. Jorge

Simple test: #include "fivewin.ch"function Main()   local oCn, oRs   ? "Connecting to FWH cloud server"   oCn   := FW_OpenAdoConnection( "MYSQL,208.91.198.197,fwhdemo,gnraofwh,Bharat@1950", .t. )   if oCn == n...

You can definitely read decimal data type also from mysql tables with ADO.

Hola buen día, hace días que estoy tratando de ver porque no puedo abrir tablas con tipo de datos decimal. Que me falta hacer? Tengo varios clientes con sqlserver y nunca tuve problemas para leer las tablas. La comunicación la realizo con ado. Estoy queriendo ver las diferencias ...

Hola gente, tengo un problema, genero esta tabla: CREATE TABLE Clientes1 ( id int(11) NOT NULL AUTO_INCREMENT, Numero decimal( 6, 0), Domicleg character( 100), Zona decimal( 10, 0), Con_iva decimal( 1, 0), Cuit character( 13), Nombre character( 40), Domic character( 40), Loca character( ...

Intenta redondeando el resultado

Not necessary. The method FieldPut() rounds off the value to the number of decimal places specified for the field.

... cTb[55]+="`id` int(6) unsigned NOT NULL auto_increment," cTb[55]+="`idestudio` int NOT NULL," cTb[55]+="`nporcentaje` decimal(4,2) default NULL," cTb[55]+="`ningreso` decimal(16,2) default NULL," cTb[55]+="`npagos` decimal(16,2) default NULL," ...

nageswaragunupudi wrote:Assuming we want 4 decimal places

Code: Select all  Expand view

n := 0.0000
msgGet( "title", "message", @n )
? n
 

Fantastic!!!!
Thank you!!!

Assuming we want 4 decimal places

Code: Select all  Expand view

n := 0.0000
msgGet( "title", "message", @n )
? n
 

... which may annoy some with all characers capitalized, but it is far better than having the field displayed as 7 characters, and then a decimal point, with no trailing data. I've spent days testing to see if I can find any other cause. There is none. I should note that if the data row ...

... en pantalla si veo bien los "pictures", el problema es que cuando lo envio a "calc" o "Excel" no respesta el punto decimal ni el separador de miles del picture y por lo tanto es como si no fuera numérico . Te adjunto una muestra de código, supongo que es una tonteria ...