Is it best to use Firebird 2 or Firebird 3?
When I use Firebird 2 or 3 and try to import the resulting created SQL file, it errors on the second table. It seems it will only import a single table.
The error I get is:
EIBNativeException ->[FireDAC][Phys][IB]Dynamic SQL Error
SQL error code = -104
Token unknown - line 9, char 0
CREATE
The generated SQL code is:
CREATE TABLE EventSocialMediaServices (
EventSocialMediaServicesID INTEGER NOT NULL,
EventsID INTEGER NOT NULL,
SocialMediaServicesID INTEGER NOT NULL,
UpdateText VARCHAR(500),
CONSTRAINT PrimaryKey6 PRIMARY KEY (EventSocialMediaServicesID)
);
CREATE TABLE Credentials (
CredentialsID INTEGER NOT NULL,
Name VARCHAR(50),
CredUsername VARCHAR(50) NOT NULL,
CredPassword VARCHAR(50) NOT NULL,
CONSTRAINT PrimaryKey3 PRIMARY KEY (CredentialsID)
);
Line 9 equates to the second create statement in the generated SQL file.
My code to import the generated SQL file is;
...
TFDQuery.SQL.LoadFromFile(GENERATED_SQL_FILE_NAME);
Am I missing something?
Thanks