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