Re: [Gretl-users] ODBC troubles
On Wed, 3 Feb 2010, Chris wrote:
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.
* What does the identifier look like?
* 5.16957e-38 looks like one of the limits of a single-precision
"float". Gretl binds the last (data) column to SQL_C_DOUBLE.
But somehow we're getting the wrong data type? Perhaps the values
in this db are stored as SQL_REAL (which has a mantissa of
precision only 7). What's the database engine?
Allin Cottrell