Re: [Gretl-users] import data via odbc

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(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users