If you wish to refer to an SQL-database (as the error-code looks like) you need to set up on ODBC-connection first. Suggest to consult the manual or try to use the wizard.
What happens if you try to load the second table as first?
If the above is all your code, surely the line FROM .... is wrong (no indication of file-type, parameters and the semicolon)
Tried the second statement first, but same error.
As regards code, I do have the semicolon at the end of the line - the code for second table in fact follows that for first table, with no file-type indicator.
I'm sure my problem is with the ODBC connection as you suggest. I have to say I find this area very confusing.
I used the OLE DB wizard to set up a connection "Co 1" - this connects to the directory in which the target directory resides. I then use the ODBC option to select the specific table within the directory. This worked fine for my first table. (In fact, once I had connected, I eventually edited direct script for my LOAD and SELECT).
I just tried another option. i started a new QVW file; set up a new connection to the same directory, this time called "Co 3". Used the ODBC option to SELECT my table; selected all fields, using "*".
However, when I run the edit script, I get the same error - maybe problem is with the particular table?
I reverted to my original QVW file, and, using the ODBC wizard, have successfully selected a number of different tables from the directory. (this time using just the SQL SELECT, rather than LOAD and SELECT).
It would seem that my coding is ok, and that my connection is ok, but that my problem is with the particular table I am using?
Sorry to lay all this on you, but I think it is worth being detailed for the sake of future readers.
To close, I would welcome any thoughts you might have on my problem table.
Not sure if this is relevant...
When I select a table using my ODBC wizard, the Fields in the table are normally listed after the * in the right hand section of the dialog box.
However, for my problem table, I can only see the * ie the individual fields are not listed.
There are 279 fields in the table.
Anything relevant here?
Sounds like some 64 bit OS / QlikView version, 32 bit ODBC driver or some postgres error we already have seen here. It shouldn't happen if you are using QlikView 10, but it does when you use version 9. I'll check for those posts in the forum, search in google for
odbc 64 32 site:qlik.com
Hope this helps
Thanks for your message. I have to confess that this is too technical for me!
I am using version 10. I also don't understand how come I can connect to some tables in the directory but not connect to others. Would the problem you describe not be preventing connection to any table?
I checked out this topic, but it is also too technical! http://community.qlik.com/forums/p/31450/121077.aspx
i would appreciate any more assistance?
Having the same issue and tryin a lot of things i finally could find that the driver needed is the "Driver do Microsoft Visual Fox Pro" but you should specify when create the DSN that there are Tables instead of BD and set the directory where the files .bdf are stored, so you can create the connection with QV using that DSN.