When I add a field to my entity:

The generated Update DDE for my Firebird table, Target Language of SQL, Target Platform of RDBMS (the only option), the SQL generated is:

ALTER TABLE "Test1"
    ADD COLUMN "City" VARCHAR(50);

It includes the COLUMN keyword, which doesn't look like it's supported on Firebird for ALTER TABLE x ADD x:

https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref50/fblangref50-ddl-table.html

Removing the COLUMN word, the code executes correctly.

Is there a SQL dialect setting I'm missing, or do I have to manually remove COLUMN from every DDE script I generate?

Thanks,

Ray

Seems like an oversight, which version of the Designer are you using?

Oops, forgot to include that.

5.8

Oops

I see the DB does allow Alter column, but not Add column. How this went unnoticed for over a decade is very strange. Will fix it in the active versions (5.10 and 5.11) As you're on 5.8 that's out of support, you have to alter the template FirebirdSpecific\CreateTableFieldInclude.lpt and remove the COLUMN keyword yourself

Fixed in hotfix builds 5.10.6 and 5.11.4

Thanks! I was planning on getting back on support in a week or two anyway.

I assumed I missed something, because I couldn't believe it was something that had been there all along. Am I the first model-first Firebird user?

Anyway, in the meantime, I'll take it out of the template.

Thanks again for your help and fast resolution.