PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
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 Robert, out., 10 2019 12:41 AM - Sem resposta
#1
Membro registado
105 mensagems
Publicado em outubro, 10 2019 - 12:41 AM
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!
→ Voltar para WINDEV 2024