Hello, everyone:
With SQLite aliases, the Objects/Data tab displays <Error> for certain
columns, but the SQL query results tab displays the data from them, in
ISO format if I remember correctly.
The particular case that I created recently is for a table with a column
that was created using DATETIME for its data type. This is probably a
copy/paste error because SQLite officially does not have such a date
type, but it works for some reason. All of the viewers known to me
display it as DATETIME, ADO.NET and JDBC display the values reasonably,
and since its value is already displayed in the query results, it
probably makes sense to synchronize the Data tab with the code that does.
Regards
Al
|