Search found 453 matches: decimal

Return to advanced search

FWHMYSQL Insert failing

Dear Friends, I'm having a huge problem with Insert/MySql. I have a Decimal field where I'm tryng to save the value 1(one), but it's saved as 0(zero). Bellow i'm showing a little sample where the problem is happening. function Main()LOCAL oCn, oAnt,nValInss,nValIn13,aVal,cvd_500  ...
by vilian
Fri Apr 05, 2024 11:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMYSQL Insert failing
Replies: 6
Views: 401

Error en Picture de footer xBrowse

... al colocar el picture en el footer. Dejo la imagen: http://www.datanet.space/fw/picture.jpg Como pueden ver, solo coloca un decimal, siendo que el picture indica dos decimales y en las filas del browse se ve con los 2 decimales. El fallo en el footers. Lo unico diferente ...
by JoseAlvarez
Thu Feb 22, 2024 8:19 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error en Picture de footer xBrowse
Replies: 4
Views: 136

De Record Set a Array ? SOLUCIONADO con oRsGetRows()

... con MySql, tengo registros que al principio tienen 10 campos alfanuméricos y al final del mismo registro hay doce campos (uno por mes) de tipo decimal con 0 decimales y finalmente hay 12 campos (uno por mes) de tipo decimal pero con 2 decimales. La pregunta: Existe alguna función que mueva ...
by Armando
Sat Feb 17, 2024 1:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: De Record Set a Array ? SOLUCIONADO con oRsGetRows()
Replies: 2
Views: 132

Re: Creating table with Trichedit

...   FWrite(oFile, "\f0\cf0 ") I understand that to insert an image file, first, you need to convert the image file to a Hexa decimal string and then insert it. // For BMPFWrite(oFile, "\intbl{\pict\wmetafile8\picw" + LTrim(Str(nImageWidth)) + ...
by Silvio.Falconi
Thu Jan 25, 2024 8:43 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Creating table with Trichedit
Replies: 18
Views: 1451

Re: Creating table with Trichedit

...   FWrite(oFile, "\f0\cf0 ") I understand that to insert an image file, first, you need to convert the image file to a Hexa decimal string and then insert it. // For BMPFWrite(oFile, "\intbl{\pict\wmetafile8\picw" + LTrim(Str(nImageWidth)) + ...
by anserkk
Thu Jan 25, 2024 4:29 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Creating table with Trichedit
Replies: 18
Views: 1451

Re: Problem with tget numeric

KArinha, podría mostrar solo un cero a la derecha en el get y luego, si el usuario escribe un número, por ejemplo 1, y luego presiona el punto decimal, el procedimiento debe colocar hasta dos números después del punto decimal y luego pasar al otro get. No uso dbf. Obtengo los datos de un navegador ...
by Silvio.Falconi
Wed Jan 17, 2024 8:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with tget numeric
Replies: 16
Views: 1432

Re: La IA contesta y se queda tan ancha

... Son muchisimos detalles y luego hay que mantenerlo. ¿ Qué le dices. En la columna de precio del mantenimiento de pedidos de compra me insertas un decimal cuando la cantidad sea inferior a uno y me sombreas la linea de rojo y si ocurre al finalizar el pedido muestra la linea con los datos de precio, ...
by paquitohm
Fri Dec 29, 2023 10:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: La IA contesta y se queda tan ancha
Replies: 13
Views: 1289

Re: problem with report to excel

... for: SUBTOTAL( -> SUBTOTAAL( SUM( --> ??? - > SOM( TRUE --> ??? -> WAAR FALSE --> ??? -> ONWAAR Language ID = 1043 Decimal separator = , Thousands separator = . List separator = ; I live in Belgium. Best regards Bart
by bart
Mon Sep 04, 2023 5:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3374

Re: xBrowse footer picture

... == "E". Converts any number formatted as string using either European notation or American notation, retaining the full precision of the decimal part. In almost all cases the function decides whether the format is European or not, by examining the number and position of "," ...
by Marc Venken
Mon Apr 03, 2023 2:15 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 730

xBrowse footer picture

... ||{ CLR_MAGENTA, } }      :MakeTotals()   END  Result: https://www.hamelau.eu/tmp/footer.jpg There are 4 decimals instead of only 2 and a decimal dot instead of comma. What can i do to display the sums according the picture clause? Regards, Detlef
by Detlef
Mon Apr 03, 2023 10:27 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 730

Re: PICTURE Decimal mediante Coma @E999.999,99

Gracias,
Voy a validarlo.
by jnavas
Mon Feb 06, 2023 9:24 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: PICTURE Decimal mediante Coma @E999.999,99
Replies: 2
Views: 212

Re: PICTURE Decimal mediante Coma @E999.999,99

Es al revés, para mostrar punto como separador de miles y coma de decimales:
@ nRow,nCol GET nValor PICTURE "@E 999,999.99"
by Sebastián Almirón
Mon Feb 06, 2023 8:50 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: PICTURE Decimal mediante Coma @E999.999,99
Replies: 2
Views: 212

PICTURE Decimal mediante Coma @E999.999,99

Saludos a todos
@ nRow,nCol GET nValor PICTURE "@E999.999,99"

Este ejemplo no muestra los puntos separadores de mil.
by jnavas
Mon Feb 06, 2023 6:57 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: PICTURE Decimal mediante Coma @E999.999,99
Replies: 2
Views: 212

Re: milliseconds()

Dear Antonio,
I found a workaround:
If I subtract a number from seconds() and add it back, it shows decimal places.

hData[ 'seconds' ] := 10 + seconds()-a -10


Best regards,
Otto
by Otto
Sat Dec 17, 2022 5:02 pm
 
Forum: mod_harbour
Topic: milliseconds()
Replies: 3
Views: 518

Re: Campo autoincremental en DBF

... { "ID", "+", 4, 0 } That is enough. Please try it. Do not worry about the width of "4". They do not represent decimal digits. The value is stored as 4 hex bytes. The maximum value in hex is 0xFFFFFFFF = 4,294,967,295. This is a lot more than enough. For Date ...
by nageswaragunupudi
Fri Nov 04, 2022 11:12 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Campo autoincremental en DBF
Replies: 7
Views: 771
Next

Return to advanced search