Hello,
I'm probably missing something because when I create a MySQL table with Aurelius I'm not able to get the varchar type and the size of the field.
This is the simple class generated by TMS Data Modeler:
[Entity]
[Table('layConnessioni')]
[Id('FOID', TIdGenerator.Guid)]
TConnessioni = class
private
[Column('OID', [TColumnProp.Required])]
FOID: TGuid;
[Column('Descrizione', [TColumnProp.Required], 64)]
FDescrizione: string;
[Column('IsDefault', [TColumnProp.Required])]
FIsDefault: integer;
public
property OID: TGuid read FOID write FOID;
property Descrizione: string read FDescrizione write FDescrizione;
property IsDefault: integer read FIsDefault write FIsDefault;
end;
Aurelius generate this script:
CREATE TABLE layConnessioni (
OID TEXT NOT NULL,
Descrizione TEXT NOT NULL,
IsDefault INTEGER NOT NULL,
CONSTRAINT PK_layConnessioni PRIMARY KEY (OID));
Why the Field "Descrizione" has the TEXT type and not varchar(64)?
From the other side this is the correct script generated by TMS Data Moduler:
CREATE TABLE layConnessioni (
OID GUID NOT NULL,
Descrizione VARCHAR(64) NOT NULL,
IsDefault SMALLINT NOT NULL DEFAULT 0,
CONSTRAINT pk_Connessioni PRIMARY KEY (OID)
);
P.S.
I really like Aurelius It's a nice product.