Re: [Gretl-users] import char/varchar columns via odbc
On Fri, 6 Nov 2015, Alessandro Astuti wrote:
Good morning everybody,
I'm currently running compiled on my own gretl 2015d with odbc support on
debian testing with gnome shell. I have correctly configured the odbc driver,
since I can connect to the db both from gretl and libreoffice base.
In gretl, importing numeric columns from a db table works correctly, but I
can't figure out how to import character values columns. For example, my
favorite test db is world, the one containing all the world countries and the
cities; I can import in gretl the columns for population and for gnp, for
example, but not the one containing the names of the countries.
If I give the command
data countries query="SELECT Name FROM Countries" --odbc
I get a series of zeros; if I add the option obs-format="%s" (the option for
string values, as I saw on the user's guide) nothing happens. Am I missing
something?
Sorry it's taking a while to get you a response on this. I (or
somebody) will need to do some experimentation and since I'm not a
regular ODBC user I'll have to set up a test rig. Anyway, your query
is not ignored and hopefully you'll get an answer before long.
Allin Cottrell