ADO CACHE
- From: "Mecch" <mecch91@xxxxxxxxx>
- Date: 11 Apr 2006 12:53:47 -0700
Hi all,
i'm using ADO to access my backend DB for an application.
I've a single global connection that I use for all the table and
dataset I create in runtime that is initialized in this way:
M_CONNECTION := TADOConnection.Create(application);
M_CONNECTION.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mioDB.mdb;Jet OLEDB:
Engine Type=4';
M_CONNECTION.Mode := cmShareExclusive;
M_CONNECTION.ConnectOptions := coConnectUnspecified;
M_CONNECTION.IsolationLevel := ilBrowse;
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.
I cannot understand what kind of problem I've please help me.
Thanks in advance,
Paolo
.
- Follow-Ups:
- Re: ADO CACHE
- From: Stephen Howe
- Re: ADO CACHE
- Prev by Date: Re: Bookmarks with .net
- Next by Date: Re: Data storage "delay"
- Previous by thread: Re: Bookmarks with .net
- Next by thread: Re: ADO CACHE
- Index(es):