pcsoft.us.windevCopyright 2026, PC SOFT10 Oct 2019 00:41:28 Z10 Oct 2019 00:41:28 ZI 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!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67319-wd24-best-way-create-table-window-from-sql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)