Re: ADO Access database, and multiusers. Again

Article View: borland.public.cppbuilder.database.ado

Article #1800

Back to borland.public.cppbuilder.database.ado Previous Next

#1800

From: Stefano
Date: Fri, 30 Jan 2004 10:18

21 lines
1722 bytes

Hi Viatcheslav V. Vassiliev,

> 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.

Yes, but when a user do a change in the DB from a client, how the other
clients can "feel" that  ?

I've tried to call Requery(), and it's work, but what message or event I've
to wait for call Requery ?

> 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.

If I use server-side curson every changes are written on DB immediately ?

Thank's for your patience! :)
Steve

Technical Details

Message-ID: <401a2f5d$2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <4018d307@newsgroups.borland.com> <40191b6c$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f3560462f9154d98
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-30 02:37:32 PST
From: "Stefano" <s.dardari@tin.it>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4018d307@newsgroups.borland.com> <40191b6c$1@newsgroups.borland.com>
Subject: Re: ADO Access database, and multiusers.  Again
Date: Fri, 30 Jan 2004 11:18:06 +0100
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 80.117.76.31
Message-ID: <401a2f5d$2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1075457885 80.117.76.31 (30 Jan 2004 02:18:05 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message