> 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
Thank you,
Artur
_______________________________________________
Gretl-devel mailing list -- gretl-devel@gretlml.univpm.it
To unsubscribe send an email to gretl-devel-le...@gretlml.univpm.it
Website:
https://gretlml.univpm.it/postorius/lists/gretl-devel.gretlml.univpm.it/
