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?
Thank you
--
Alessandro Astuti