tablename not recognized in direct sql

Often a tablename is not recognized in an UPDATE-statement. It works fine in SELECT-statements.

Your question is a bit vague. Since you state ‘often’, it suggests you are using Tools->SQL... from the main screen.

I have not experienced any problems with running any statements there. The probable problem is the way you format the table name. The best bet is to make sure your table name is surrounded by quotes - "MyTable". This is not needed if your table name was created using all caps without any spaces or punctuation. This also holds true for field names.

The Query section is a bit different. In that screen there is a built in interpreter which is more lenient. However, it is best to be consistent. The Run SQL command directly.. button has no effect on this. Of course, you cannot run any statements here except Select statements.

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).