Re: No update of DBGrid based on TADOQuery?

Anotrher strange thing:
Requery and Repaint, called immediately after the function that calls
Post, obviously have no effect. But when they are called from the
OnClick procedure of a button, they work.

However, the grid should update itself automatically; the user is not
supposed to press abutton to refresh it...

Unfortunately JET engine has a latency built into it and that is what you are
seeing
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200300

You can try this from your code

adoconnection1.properties.Item['Jet OLEDB:Page Timeout'].Value:=500;

This should overrides the registry setting and change it to 500 ms (needs to be
applied after the connection is opened).


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Quantcast