Important feature of TIBCQuery is that TIBCQuery is able to generate DML statements for updating data on the server itself. Remember that TIBCQuery is able to generate statements for updating only one table. By default TIBCQuery uses the first table from FROM clause. You should assign table name to UpdatingTable property if another table is used for updating. If you need more complex SQL statements than generated by TIBCQuery, use SQLInsert, SQLUpdate, SQLDelete properties to assign any SQL statements. It is not obligatory to assign all the properties, not assigned are still generated automatically.