onTranslateMessage event

[Kegel]

Can't get the onTranslateMessage event to be fired on a OracleDataset component?

I have a oracle table with a named primary key constraint. Setting the EnforceConstraints property to true should fire a OnTranslateMessage event - or?

 

[Marco Kalter]

Only if the record is inserted/updated through a Post operation.

------------------
Marco Kalter
Allround Automations

 

[Kegel]

Thanks! It was the missing piece of information. Normally I use somthing like this

OracleDataset1.close();
OracleDataset1.sql.clear();
Oracledataset1.sql.text := 'insert into test (keyfield) values (1)';
Oracledataset1.execSQL();
Oracledataset.session.commit;

that is a post operation in my world ;-). But this works fine:

OracleDataset1.edit();
OracleDataset1.appendrecord([1]);
OracleDataset1.Post();

hmm, but with 200 attributtes and only some of them shall be updated....