Good Morning Mr Rao, I made a test with oCN:InsertSQ() and it's also returning a wrong sentence. It's returning this: INSERT INTO `folha` ( `cemp`,`nfolha`,`cmat`,`cvandes`,`cvdorig`,`val_inf`, `val_calc` ,`total_inc`,`filial`,`clotacao`,`prazo`,`situacao` ) VALUES ( '047','9WZ','00261','500','500',...
Gracias Armando, cree esta funcion FUNCTION Redondear(numero) *--------------------------- Local val_num := Val(SubStr(Str(numero,9),-1)) Local Valor := 0 If val_num>=1 .AND. val_num<=5 valor = numero - val_num ElseIf val_num>= 6 .AND. val_num<= 9 valor = numero + ...
Before saving, use VAL() unlike you I try my programs over and over again and don't hand the client something that doesn't work well. It's not easy at all, as I told you in the Xbrowse table I have the numeric figures with commas, ...
oGet[1]:bGotFocus := {|| (oGet[1]:cText := STR(VAL(oGet[1]:cText) *100,6), oGet[1]:Refresh(),oGet[1]:SelectAll()) } Cesar, changed the GETs to character that you get the inputstyle you wanted.
Yes but nvar Is text array but i have numbers no texts
oGet[1]:bGotFocus := {|| (oGet[1]:cText := STR(VAL(oGet[1]:cText) *100,6), oGet[1]:Refresh(),oGet[1]:SelectAll()) } Cesar, changed the GETs to character that you get the inputstyle you wanted.
Hola gente, en la versión 23.07 me da este error, cosa que en la 22.12 no. Me falta agregar alguna librería? Este es parte del código: *----------------- DEFINE WINDOW oWndChild MDICHILD OF oWnd FROM 0, 0 TO 24, 79TITLE "Carga Informe de Auditoría " font oFont11 DEFINE DIALOG princfac RESO...
You are right, Antonio. My problem is to let an user input an integer value with a maximum of 6 digits. But without showing a zero in the get control. I could take a string value with picture "999999" and after transform it to numeric with val( cVar ...
Estimados compañeros buenos dias molesto su atencion con un tema que me esta produciendo dolores de cabeza tengo una instalacion con ads server y tablas DBF en esta instalacion debo cargar cada noche miles de registros a una base de datos sql server ( ese sql esta en el mismo server ) el caso es que...
I found the cause of more than 2 decimals in the footer sum.. My column value was computed by multiplying a numeric value by a val( alltrim( cValue ) ) . The xBrowse column was showing correct values with 2 decimals according to the column picture clause. But ...
Hola, necesito hacer una pantalla con 4 folders de las cuales 3 tienen listbox, el problrma que tengo es que no muestran los datos, muestra un solo registro, a persar de que los datos se graban bien en las dbf. DEFINE WINDOW oWndChild MDICHILD OF oWnd FROM 0, 0 TO 24, 79TITLE "Carga Informe de ...