[Gretl-devel] Re: Problem with ODBC query

> On Mon, 23 Mar 2020, atecon(a)posteo.de wrote: > > > I see what you mean (I think!). Getting this right involves some > brain-bending mapping between 1-based SQL columns, 0-based C arrays, > and 1-based dataset series. But I believe this should now work > better in current git. > > Allin Hi Allin, sorry for another post on this. While the working of SQL_DATE works nicely, I still get wrongly fetched data if the first selected column is of type SQL_DATE, the second is of type SQL_VARCHAR -- the format of the remaining ones does not matter. QUERY 1: WORKS col 1 (DATUM): data_type SQL_DATE, size 10, digits 0, nullable 2 (?) col 2 (KLIMA): data_type SQL_DECIMAL, size 4, digits 1, nullable 2 (?) binding col 2 to xt[0] col 3 (SEKTOR): data_type SQL_VARCHAR, size 20, digits 0, nullable 2 (?) binding col 3 to strvals[1] (len = 20) <> nulldata NOBS -p setobs 7 2018-01-01 --time-series string Q = "SELECT DATUM, KLIMA, SEKTOR FROM ABC.DEF" data klima sektor obs-format="%s" query=Q --odbc --verbose print dataset -o </> index klima sektor 2018-01-01 1 104.8 gesamt 2018-01-02 2 104.8 gesamt 2018-01-03 3 104.8 gesamt 2018-01-04 4 104.8 gesamt 2018-01-05 5 104.8 gesamt QUERY 2: FAILS <> nulldata NOBS -p setobs 7 2018-01-01 --time-series string Q = "SELECT DATUM, SEKTOR, KLIMA FROM ABC.DEF" data sektor klima obs-format="%s" query=Q --odbc print dataset -o </> As you can see, "sektor" has no string-values any more and for "klima" are values are missing. index sektor klima 2018-01-01 1 1 2018-01-02 2 1 2018-01-03 3 1 2018-01-04 4 1 2018-01-05 5 1