Refreshing queries (TADO)

I'm not exactly what you'd call database literate, but I've wired up some
TADO components to view/edit a set of tables and I'm having a bit of trouble
understanding the refresh logic.

Here's what I've got:

One TADOConnection (to an MDB file for now).

>From that TADOConnection I have several TADOQuery components, each with
their own TDataSource going to a TDBGrid. Grids are on various tabs of a
TTab***. Everything works wonderfully. Until...

When I make changes to a table, specifically by using .Execute with a SQL
string on the TADOConnection to add rows the grids do not reflect the
changes. The .Refresh method on the various components have no effect. In
order to get the data refreshed I need to

.Active:=false
.active:=true

for each query. While it works, it's kind of slow and ugly.

(1) Is this normal?
(2) Is there a better way, or a setting I'm missing?

Thanks,
Dan


.

Quantcast