Extend SX_USERS using DataModeler

[Zelaya_Omar]

Hi, I wanto to add SX_USERS to my DB desing using DataModeler.(SX.. Tables in Same Database of App Data) so I can add a foreign relation from SX_USERS to my app tables.

¿The above would be ok?

Thanks in advance,

Omar Zelaya

[wlandgraf (Wagner Landgraf)]

To extend sx_users table you should create a new Aurelius class inheriting from the base class.
This support question explains how to do it:

Addtional Attributes for User Class

All you have to do is set the property in TSphinxConfig component: SphinxConfig1.UserClass := TMyUser; And then declare your TMyUser class inheriting from TUser: uses Bcl.Types.Nullable, Aurelius.Mapping.Attributes, Sphinx.Consts, Sphinx.Entities; {$RTTI EXPLICIT METHODS([vcProtected..vcPublished])} [Entity] [Model(cSphinxModelName)] [DiscriminatorValue('myuser')] TMyUser = class(TUser) strict private [Column('profile_url', [], 255)] FProfileUrl: NullableString;…

[Zelaya_Omar]

Hi,

It is possible to inherited from a base class using Datamodeler or do I have to manually make the changes every time I export from datamodeler to Aurelius?

Thanks in advance,

Omar Zelaya

[wlandgraf (Wagner Landgraf)]

Why would you need to change it every time you export from Data Modeler?
Just create the class manually from code, and keep it there. No need to involve Data Modeler here.

[Zelaya_Omar]

Got it. Thanks!