Re: [Gretl-users] ODBC troubles
On Thu, 4 Feb 2010, Riccardo (Jack) Lucchetti wrote:
Chris: it may be a good idea to set up a linux box (maybe even a
VM may be enough) with MySQL or whatever else you like and use a
fake database with the same structure as the one you're querying
to tell gretl bugs from the ones on the DBMS side.
I'd see if the current gretl snapshot for Windows imports
the data in question correctly. But if it doesn't then Jack's
idea is well worth trying.
>> As a side note, do you know if anyone is working on updating
the
>> import features to allow multiple variable imports?
>
> Nobody's working on that, that I know of. But it's not too hard
> to replicate your query string with modification so as to grab as
> many variables as you need.
True. In the future, it may be nice to provide the functionality
to import more than one series at once, but it doesn't sound
high priority to me. Do you agree, Allin?
Well, on reflection it seemed a bit lame that we didn't support
extracting multiple series per query. That's now fixed in CVS,
and it'll be in the Windows snapshot later today. The new syntax
is
data series1 series2 ... [obs-format=fmt] query=SQLquery --odbc
For example
string SqlQry = "SELECT foo1, foo2 FROM bar"
data x y query=SqlQry --odbc
The new tag "query=" is needed, so we don't mix up series names
with the start of the query. But for backward compatibility the
old syntax still works, to import a single series.
Allin.