Update TOracleDataSet CommandText MIDAS

[wru]

Hi,
I'm using MIDAS, TOracleDataSet on serwer side and TClientDataSet on client. Depends on user changes I need to build SQL string for different tables and fields " in where" clause. In MIDAS case I can't use the 'substitue' type variables. Everything works fine for select, but if I try to update values I dicovered using Debug property that the Update is done using where cluse for all fields in selection.
It cause the problem when I have more then one row with the same values.!!! I can't update this row!!!
(I'm using D6 SP2,DOA 3.4.5.1).Select string contain rowid
Does the anybody have the same problem?

 

[wru]

i found out the answer , to use commandtext in ClientDataSet TPrivider option allow commandtext = True, but more TProvider.ResolveToDataSet=True (!thanks for fzapata!!), sgl must be with rowid.
It takes rowid in where clause to update record

Originally posted by wru:
Hi,
I'm using MIDAS, TOracleDataSet on serwer side and TClientDataSet on client. Depends on user changes I need to build SQL string for different tables and fields " in where" clause. In MIDAS case I can't use the 'substitue' type variables. Everything works fine for select, but if I try to update values I dicovered using Debug property that the Update is done using where cluse for all fields in selection.
It cause the problem when I have more then one row with the same values.!!! I can't update this row!!!
(I'm using D6 SP2,DOA 3.4.5.1).Select string contain rowid
Does the anybody have the same problem?