Mur
User
Platinum Boarder
| Posts: 116 |   |
Karma: 0
|
|
RE: TOCIUpadeSQL
|
|
Posted: 2002/05/28 00:10 |
|
|
|
|
OCIQuery1.SQL.Text := 'select t.*, t.rowid from mytab';
OCIQuery1.UpdateObject := OCIUpdateSQL1;
OCIUpdateSQL1.TableName := 'mytab';
Fill these properties and UpdateSQL will work.
Don't forget to select ROWID field from your table. If you don't want to select rowid, then you should manually set property ProviderFlags:=[pfInKey] of fields which make up primary key in updated table. For example:
OCIQuery1.SQL.Text := 'select ID, NAME from MYTAB'
OCIQuery1.Prepare;
OCIQuery1.FieldByName('ID').ProviderFlags := [pfInKey];
|
|
