Re: ADO CACHE

I encounter problem with cache when I add a new record in a table and
immediatly I access it from a new table component that is using always
the same connection.
I noted that if I call two time the same function that do the user
output of the database content I can see the correct output. Calling
the function only a single time I've not the new record showed and I've
to wait a new refresh.

It is well known. It is part of Jet latency.
See here
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200300

You also might want to see this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefjetprovspec.asp
and set things like
DBPROP_JETOLEDB_PAGETIMEOUT to 0

See also here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.asp?frame

and see conversation here

http://tinyurl.com/hgqna

Stephen Howe


.

Loading