|
| Inicio → WINDEV 2024 → [WD24] Best way to create a table (on a window) from a SQL view |
| [WD24] Best way to create a table (on a window) from a SQL view |
| Iniciado por rob, 10,oct. 2019 00:41 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
105 mensajes |
|
| Publicado el 10,octubre 2019 - 00:41 |
I have a table in SQL that has a datetime field which stores it's data in UTC.
I can create a view in SQL that will convert that UTC time to the user's local time easily, but I can't seem to get that view into my WinDev program.
The analysis won't import the view saying it ran into errors, but showing a blank error window.
The analysis complains about the SQL code of the query not being compatible with HFSQL when I create it directly there.
(The database is SQL, not HFSQL, and running the test works fine)
Also I can't seem to select that view as a data source for the table.
My goal is to have a table in a window displaying this data for the user. And converting it to local time for them will be helpful.
Thanks! |
| |
| |
| | | |
|
| | | | |
| | |
|