I have been trying to discover how I can, in Data Modeler, assert that a non-key column is UNIQUE, so it can be referenced by a foreign key constraint. So far, I have not found a solution which results in a script acceptable to FireBird 2.5.
Thanks. I did that, but it still complains in the script, when trying to set the foreign key. I can send a project file, if you wish. I am trying to run the script in FlameRobin, where I get better feedback than in Delphi.
Send me the project file and then script then, I will take a look.
I sent a ZIP file, but did not include the script, as it is simply the one generated by DM.