ORM Update – Tablename gets quoted 3 times instead of 1

[mrluigi2017]

Hi,

When I do an ORM.Update I get a dynamic SQL error. In Devart’s DBMonitor tool I see that for some reason the table name in the where clause is quoted 3 times instead of 1:

UPDATE “Person” SET “FirstName” = :FirstName,”LastName” = :LastName,”Notes” = :Notes WHERE “””Person”””.”PersonID” = :KBMMW_KEY_PersonID

The strange thing is that when I do:

Orm.Query<TPerson>([APersonID], mwoqoEQ, FTransaction, []);

It all works fine.

Any suggestions what may cause this problem?

D10.4.2

KbmMW 5.19.00

Unidac 9.3.0

Thanks in advance,

Luigi

 

 

[kimbomadsen]

What have you setup the connection pool as?
And what metadata component are you using with it?

/Kim

[mrluigi2017]

The connection pool is a TkbmMWUNIDACConnectionPool with a kbmMWInterbaseMetaData and a kbmMWInterbaseSQLRewriter.

[mrluigi2017]

Message removed.

• This reply was modified 2 years, 11 months ago by mrluigi2017.

[mrluigi2017]

I have written al little test application and I noticed that the tripple quotes only appear when quotes are used when creating tables. Since this is a new project I have decided to use uppercase and no quotes for tables names (and other identifiers).

[kimbomadsen]

Can you show me a small sample here of how you were creating the tables with quotes, so I get an understanding of if it is something that I need to look into 🙂
/Kim

[kimbomadsen]

Hi,

I have fixed it for next release.

/Kim

[Author]

Posts