ClientDataSet multi-table query single table update

The query SQL: select * from T1, T2

ClientDataSet. ApplyUpdates (0) update will fail, but I just want to update to the T1

To solve the

CodePudding user response:

Don't make, if you don't support custom update, multi-table update problems, because the associated table contains, in May will be change
So if you want to use more table update, it is best that can write their own update statement, such as UniDac UpdateSql of that kind

CodePudding user response:

If the update sheet, I need now,

CodePudding user response:

This is a problem:
SOL from two tables, read data, update the data of a table, only
It is recommended to use the UpDate statement:
The UpDate T1 set field 1=0, field 2=' 'where ID=' + # 39 + ID + # 39 '

Only updates listed T1 field,

CodePudding user response:

reference lyhoo163 reply: 3/f

this is a problem:
SOL from two tables, read data, update the data of a table, only
It is recommended to use the UpDate statement:
The UpDate T1 set field 1=0, field 2=' 'where ID=' + # 39 + ID + # 39 '

Only updates listed T1 field,

A a field list no problem,
Set the field to get the value of the how to write, I change so much value, without peer,

CodePudding user response:

Have one I???????

CodePudding user response:

Through the
DBGrid1. The DataSource. The DataSet. FieldByName (' field name). AsString;
Get the value,

CodePudding user response:

Suggest use SQL statements to UPDATE, so simple, too much trouble with controls