ORM doesn’t fit for working with Firebird and UNIDAC

[VadimMest]

Hi

I tried use ORM with Firebird database + UNIDAC and I failed. There are a lots of errors and problem. As example

1. Modify Colum: ALTER TABLE MR_DOC MODIFY COLUMN DATEDOC TIMESTAMP
2. Some error with transaction in  TkbmMWCustomConnection.StartTransaction (Can’t perform operation on active transaction)

Does it even work?

 

• This topic was modified 4 years, 10 months ago by VadimMest.

[kimbomadsen]

Hi,

1)
I can’t guarantee every variation of DB adapter vs DB and versions will as the number of combinations are huge!

I however can tell that the SQL rewriting was tested at the time of doing them, but it is not the same as there can’t be scenarios which needs attention.

I have corrected the “alter table alter column” rewriting for next version, so default for ANSI92 SQL is correct. Interbase/Firebird use ANSI92 syntax, and then specialized Oracle and MSSQL rewriters to use “modify”.

2)
I am not aware about transactions not working as they should in kbmMW (using them every day). Can you be more specific in what you see do not work?

best regards

Kim/C4D

[VadimMest]

Dear Kim

I fixed your code for changing metadata in Firebird  tables (SQLDialect 1). I  changed some sql and data type definitions.

Can I send changed units to you?

 

[kimbomadsen]

Hi,

Yes please. Send to kbm@components4developers.com

best  regards

Kim/c4d

[Author]

Posts