TEcho with firebird

I am trying to synchronize FireBird DB using TEcho,
and testing using TMS' demo program. (Documents\TMSSoftware\TMS Echo\Demos\basic\EchoBasicDemo.dproj)

The demo program works fine with SQLite,
After modifying the program to work with FireBird DB, an error occurs.


Debugger Exception Notification

Project EchoBasicDemo.exe raised exception class EMappingNotFound with message 'Cannot find mapping [Id] on class TTblMsLine.'.

I attached the tested source code and DB files together.
Please check if you can fix this.

basic.FB.zip (661.9 KB)

Thank you. Have a good day

Hi. As the error message says you need to specify the Identifier of the class using [Id] attribute, ex:

  [Entity]
  [Table('TBL_MS_LINE')]
  [Id('FMS_STR_ID', TIdGenerator.IdentityOrSequence)]  // here
  TTbMsLine = class
  private
    [Column('MS_STR_ID', [TColumnProp.Required, TColumnProp.NoUpdate])]
    FMS_STR_ID: Integer;
  {...} 

HTH,

2 Likes

BTW,

It worked fine "with SQLite" because the exemple used [Automaping] and the Identification member was named FId, in this case you don't need to explicitly use the [Id] mapping attribute.

Regards,

2 Likes

Hi.
As you told me, I have the wrong column setup.
I found a column setup method in the TAurelius manual.
And now it works fine.
Thank you! :smiley:

2 Likes

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.