Fuente: Ayuda de Delphi
Cita:
When the BDE-enabled dataset represents a stored procedure or a query that is not "live", it is not possible to apply updates directly from the dataset. Such datasets may also cause a problem when you use a client dataset to cache updates. Whether you are using the BDE or a client dataset to cache updates, you can handle these problem datasets by using an update object.
The update object actually encapsulates three TQuery components. Each of these query components perform a single update task. One query component provides an SQL UPDATE statement for modifying existing records; a second query component provides an INSERT statement to add new records to a table; and a third component provides a DELETE statement to remove records from a table.
|
Espero que entiendas, te explico, por ejemplo si tienes un DBgrid, y actualizas uno o varios de sus campos, lo unico que tendras que hacer para guardar o cancelar los campos sera:
Código Delphi
[-]
Query1.ApplyUpdates;
Query1.CommitUpdates;
por que el UpdateSQL gracias al cached update del Query, el UpdateSQL actualiza la DB.
salu2.