Double Columns Values by Insert in updateable TOracleDataSet with Oracle Lite

[dmitri]

Hi all,

could have someone problems with updateable
TOracleDataSet by insert and post.

I have next problem:
I use Oracle Lite. In one table i have to insert new record with updateable dataSet.
I set two values for two columns, they are different, after post(commit) value from
one column will be saved in both columns.

is it a problem with Oracle Lite???
Strange is that if i use another columns i don't have this problem, only with one combination of two fields but they don't have any special constraints or like.

any ideas

regards

Dmitri

 

[Marco Kalter]

Can you let me know what the column names are, and can you additionally set TOracleDataSet.Debug to True to verify what the exact SQL Insert statement is when you post this record?

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