Thanks Allin,
From reading the manual that bit was there because I am importing 2
columns,
the first one being an identifier. When I remove the first column from my
select statement I can import data from both my big query and my test query,
but all the data shows up as "5.16957e-38" not the data that shows up when I
run the same query in query analyzer.
Thanks,
Chris
On Wed, Feb 3, 2010 at 10:37 AM, Allin Cottrell <cottrell(a)wfu.edu> wrote:
On Wed, 3 Feb 2010, Chris wrote:
> Thanks for the help Allin,
>
> That was just my own lack of understanding of how to use that command. So
> now, thanks to your help, I have it working. The ODBC command executes
and
> it pulls 217 observations, which is the same number I would expect from
> running the sql query in query analyzer. However, now that it's in gretl,
> when I try to view the dat I get an "maxbufftemp: no valid values" error,
> however, when I look at the data in query analyzer It's there (example
piece
> of data from query analyzer: 39.900"
I think the problem is that you're using
obs-format="%d"
which is designed for integer data, but with values like 39.900
you actually have floating-point data. Try dropping the format
string:
data maxbufftemp @QRY1 --odbc
Allin Cottrell
_______________________________________________
Gretl-users mailing list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users