xdata aurelius fieldnames with - display sql errors

[wlandgraf (Wagner Landgraf)]

E-Mail is not a valid field name, as it contains a hyphen (which is a minus sign). Quickest way to solve this is simply wrap the field name with quotes or the back tick (MySQL specific):

[Column('"E-Mail"', [], 60)]

or

[Column('`E-Mail`', [], 60)]

Alternatively if you want ao more general approach you can use the OnGetIdName event:

Support for quoted table/fieldname

You can use OnGetIdName event to tell Aurelius which identifiers should be double quoted: (TSQLGeneratorRegister.GetInstance.GetGenerator('MSSQL') as TAnsiSQLGenerator) .OnGetIdName := function(AName: string): string begin Result := AName; if SameText(AName, 'User') then Result := '"' + AName + '"'; end;