dbpPopupDateSelector
Quote from neobook on September 23, 2019, 4:10 amaction button left click is:
dbpPopupDateSelector "Left=625;Top=153;InitialDate=;DateFormat=dd/mm/yyyy" "[almanaque]"
If "[DATOS.TABLA1.ID]" ">" "0"
dbpStrReplace "datos" "Tabla1" "FECHA" "[datos.Tabla1.FECHA]" "[almanaque]"
Else
EndIf
action button left click is:
dbpPopupDateSelector "Left=625;Top=153;InitialDate=;DateFormat=dd/mm/yyyy" "[almanaque]"
If "[DATOS.TABLA1.ID]" ">" "0"
dbpStrReplace "datos" "Tabla1" "FECHA" "[datos.Tabla1.FECHA]" "[almanaque]"
Else
EndIf
- You need to login to have access to uploads.
Quote from Gaev on September 23, 2019, 4:57 am@neobook
If you only want to update the FECHA field in the currently active record, DON'T use dbpStrReplace ... Help file says ...
Replace all occurrences of a string in a single field. If a query is active, only records matching the search criteria will be copied. You can use this action to perform a search and replace across an entire table.
... just do this ...
dbpPopupDateSelector "Left=625;Top=153;InitialDate=;DateFormat=dd/mm/yyyy" "[almanaque]" SetVar "[datos.Tabla1.FECHA]" "[almanaque]"
If you only want to update the FECHA field in the currently active record, DON'T use dbpStrReplace ... Help file says ...
Replace all occurrences of a string in a single field. If a query is active, only records matching the search criteria will be copied. You can use this action to perform a search and replace across an entire table.
... just do this ...
dbpPopupDateSelector "Left=625;Top=153;InitialDate=;DateFormat=dd/mm/yyyy" "[almanaque]" SetVar "[datos.Tabla1.FECHA]" "[almanaque]"
Quote from neobook on September 23, 2019, 12:15 pmHola amigo.
Sigue sin cambiar, no me modifica la fecha por la seleccionada. Todo sigue igual.
Hola amigo.
Sigue sin cambiar, no me modifica la fecha por la seleccionada. Todo sigue igual.
Uploaded files:- You need to login to have access to uploads.
Quote from Gaev on September 23, 2019, 3:53 pm@neobook
Sigue sin cambiar, no me modifica la fecha por la seleccionada. Todo sigue igual
Still unchanged, I do not change the date for the selected one. Everything remains the same
I think I know what the problem is ... a closer look at the images you provided shows that the FECHA field value is 0,0012657531 ... I believe the comma is used as the decimal point in your country (dot in North America and UK) ... so the value represents 22 divided by 09 divided by 2019 ... so VisualNEOWin is doing math on the value supplied by
[DateShort][almanaque] ... so try this ...SetVar "[datos.Tabla1.FECHA]" "![almanaque]"... notice the ! before [almanaque] ... that should prevent VisualNEOWin from doing the math.
Sigue sin cambiar, no me modifica la fecha por la seleccionada. Todo sigue igual
Still unchanged, I do not change the date for the selected one. Everything remains the same
I think I know what the problem is ... a closer look at the images you provided shows that the FECHA field value is 0,0012657531 ... I believe the comma is used as the decimal point in your country (dot in North America and UK) ... so the value represents 22 divided by 09 divided by 2019 ... so VisualNEOWin is doing math on the value supplied by [DateShort] [almanaque] ... so try this ...
SetVar "[datos.Tabla1.FECHA]" "![almanaque]"
... notice the ! before [almanaque] ... that should prevent VisualNEOWin from doing the math.