hsteigstra
Member²
It seems there is a bug in the update query. Happens only when I do this:
* DOA query collects data and a decoded "boolean" derived from a secondary table.
* dsp.ProviderFlags for this field pfInUpdate & pfInWhere = false prohibiting updates for this non-existing field.
* On the client side I change the value of this field.
* This record is included in the Delta, but no changes are present...
* When I apply the changes the OracleMonitor comes with a ORA-00971 missing SET keyword. The exact SQL is:
update "ANALYTE_SETTING" se
where
"SCM_ID" = :V0 and
"SRV_ID" = :V1 and
"PTP_ID" = :V2 and
"CTR_ID" = :V3 and
"ANL_ID" = :V4
I do this with the intention to handle the changed boolean separately before applying the other changes.
Best regards, Herman Steigstra
* DOA query collects data and a decoded "boolean" derived from a secondary table.
* dsp.ProviderFlags for this field pfInUpdate & pfInWhere = false prohibiting updates for this non-existing field.
* On the client side I change the value of this field.
* This record is included in the Delta, but no changes are present...
* When I apply the changes the OracleMonitor comes with a ORA-00971 missing SET keyword. The exact SQL is:
update "ANALYTE_SETTING" se
where
"SCM_ID" = :V0 and
"SRV_ID" = :V1 and
"PTP_ID" = :V2 and
"CTR_ID" = :V3 and
"ANL_ID" = :V4
I do this with the intention to handle the changed boolean separately before applying the other changes.
Best regards, Herman Steigstra
