generated sql statements for DOA components

[Johan R]

The DOA components generate their own sql statements, this depends on the fields that are changed.

For example: when a Toracledataset contains 3 fields an only 2 are changed, the TOracledataset generates an sql statement like

update

set = :v1
, = :v2

or

insert into

(field1, field2)
values
pv1, v2)

Because has not been changed, it is not in the generated sql statement.

Because of the shared pool in Oracle (which contains the last statements) I would like that the TOracleDataset component generates always the same insert and update statements for a specific set of data (not depending on which fields are changed)

Is that possible?

 

[Marco Kalter]

It is currently not possible, but I have added an option for this to the list of enhancement requests.

 

[Andrey Maximenko. Ukraine]

How about always update primary key, if you updated any simple field's?

 

[Marco Kalter]

Why do you want to always update the primary key?

 

[Andrey Maximenko. Ukraine]

Johan R
I would like that the TOracleDataset component generates always the same insert and update statements for a specific set of data (not depending on which fields are changed)

 

[Marco Kalter]

Okay, I see . The primary columns would indeed always be included.