🚀 go-pugleaf

>What I need to do is to access the same file database from 2 or more
instance of the same application, and to SYNC all the edit/insert/delete
operation to all clients.

You should either use server-side cursor or call Requery() to renew data.
Client-side cursor fetches all rows and work with in-memory cache, not with
data in database.

>a client-side cursor, just because I need to get a
> SELECT result set.

You may get SELECT with server-side cursor. Generally you may execute any
SQL statement for server-side cursor as for client-side cursor. However
sometimes recordset may become read-only and even forward-only.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Stefano" <p.bianchi@tin.it> �������/�������� � �������� ���������:
news:4018d307@newsgroups.borland.com...
> Hi all,
> after many question, and thanks to the people that have show the right
way,
> I've just modified the ADOConnection Properties with :
>
> Jet OLEDB:Flush Transaction Timeout = 2000
>
> and
>
> Jet OLEDB:Shared Async Delay = 2000
>
> What I need to do is to access the same file database from 2 or more
> instance of the same application, and to SYNC all the edit/insert/delete
> operation to all clients.
>
> I use ADOConnection, ADODataSet, ADODataSource and a DBGrid (I use this
just
> as a test form), and a client-side cursor, just because I need to get a
> SELECT result set. I've set the cmShareDenyNone in the ADOConnection->Mode
> property.
>
> How can I trig all the users database operations ?
>
> When I try with this sample application I've monitored all the component
> events with breakpoint, but if I do any DB edit/delete/insert operation
> nothing appen on the other application connected to same database file.
>
> What is wrong ?
>
> Do I've to use an ADORDSConnection component instead of normal
ADOConnection
> ?
>
> Thank's to anyone tha can help me.
>
> Steve
>
>
>
>
>