Execute SQL - Table name with spaces

[Garry Claridge]

Does anybody know how to get around the problem of accessing tables with names containing spaces?

Usually, I would use ` character to delimit the name, however this does not seem to work with "Execute SQL".

I cannot change the table names as it is Microsoft Dynamics :

Thank you.

Garry

[Garry Claridge]

Got it :

In the "Calculated SQL" I can use double quotes " around database objects; i.e. Table and Field names.

Hence the FM calculation may look like this:

"INSERT INTO "Web Long Description" ("Item No_",......

Garry