[Gretl-devel] Re: Problem with ODBC query

On Sat, 21 Mar 2020, Artur Tarassow wrote: > Sorry, but I've explored some further issues: > > 1) "DATUM" is a date string in the format YYYY-MM-DD. This format seems to > cause trouble as an error occurs for the query: > QUERY: "SELECT DATUM FROM OV_AS_LAB_LUMEN.IFO_DATA LIMIT 10" > > <output> > SQL query: 'SELECT DATUM FROM OV_AS_LAB_LUMEN.IFO_DATA LIMIT 10' > SQLConnect(dbc,...): SQL_SUCCESS > Number of columns = 1 > col 1 (DATUM): data_type invalid, size 10, digits 0, invalid 'nullable' > value! Hold it there! What's the actual SQL data type of this column? Obviously it's not recognized by gretl (though "invalid" is probably too strong a judgment). You say it's a "date string", and gretl recognizes these string types: SQL_CHAR, SQL_VARCHAR, SQL_WCHAR and SQL_WVARCHAR. We don't currently handle the SQL_DATE type. That's something I'm working on right now, but it doesn't sound as if this is an SQL_DATE column.