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