This is what Sybase Error Code Table says
You have misspelled the name of a table, or you have connected with a different user ID and forgotten to qualify a table name with a user name. For example, you might have referred to employee instead of "DBA".employee,
This article about executesql may be of interest.
FM 12 ExecuteSQL, part 1
Posted on April 16, 2012
In fact there was a combination of the username and a syntax error. When you import function in FM12 and log in to your source you get a "guide" to import data. The guide presents the tables and fields and you can build your sql-question. The problem is that when you use the guide you will get the error I got. The suggestion from the guide looks like this:SELECT "ABCKOD"."abc_ben"FROM "ABCKOD"But that does not work. The solution is to add the user and remove the "".SELECT DB.ABCKOD.abc_benFROM DB.ABCKOD...will do. Pretty simple, but I have struggled a couple of days with different ODBC-drivers and I thought it had something to do with that.Thanks also for the link to the guide.BrSimon
BTW: I think that only works because you have no spaces in the table or user names.
I guess so, but the problem I had was that it did not work with the citation marks. What would be the correct syntax to write the (actually functioning) syntax below, but with citation marks? BR S
Single quotation marks are more common, I think. (That's why I love the SQL Standard: there are just so many to choose from...)