Hi there,

I tried the simple queries, but the result is still the same. The 'DataDu' is not read in as a series with zeros but has the
documented destructive effect on the oberservation string which leads to completely empty series for both x1 and x2.

Leon

Am 12.03.2011 23:36, schrieb Allin Cottrell: 
On Sat, 12 Mar 2011, Leon Unger wrote:

after trying to replicate the 'sql yes but series no' outcome with that
dummy db (I've sent) I'm of the opinion
that the bug is caused by access, since with mysql you do not encounter
such problems.
Further I agree that the user has to specify a correct sql statement.
But hey,sometimes it may happen to forget something ;-)
Ok. Nevertheless, it's an intersting topic and this time I can give you
more information...

Thanks -- and I agree, it's interesting -- but I'm not an SQL
expert and some of the syntax in your queries defeats me (and
doesn't seem to work with mysql/unixODBC).

Could you try these simpler queries and see what happens?

string Q1 = "SELECT FL, SL, TL, Data, Data2 FROM Data_StringL"
string Q2 = "SELECT FL, SL, TL, Data, DataDu FROM Data_StringL"

In the context, that is, of

 data x1 x2 obs-format="%d:%d:%d" query=Q --odbc

where 'Q' = Q1 or Q2.

Here, both Q1 and Q2 work OK, although in the case of Q2 the
imported series x2 is all zeros.

Allin Cottrell
_______________________________________________
Gretl-users mailing list
Gretl-users@lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users