PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → 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
Started by Robert, Oct., 10 2019 12:41 AM - No answer
#1
Registered member
105 messages
Posted on October, 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!
→ Go back to WINDEV 2024