From gretl, if I run
? open dsn=polls user=phl --odbc
Connected to ODBC data source 'polls'
? data dem rep query="select democrat,republican from generic" --odbc
? print dem
The symbol 'dem' is undefined
However, if I precede the data command with "smpl 1 228", gretl imports
all 228 rows. Is there a way to import data from SQL that doesn't
require knowing the number of observations in advance? I'd like just to
point gretl at a database, give it a query like the above, and have it
populate the database with all the records it finds? Is that not
possible? It works like that when importing data from CSV files.
Thanks!
Peter
Dr. Peter H. Lemieux
politicsbythenumbers.org
politicsbythenumbers(a)gmail.com
@PeterHLemieux