Re: Using Access database in a network with ADO

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

Article #62

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

#62

From: Mario Sernicola
Date: Thu, 29 Nov 2007 07:44

18 lines
1812 bytes

How can I do in order to "flush any buffers, close the database 
connection, open it"? Which are the methods?


Mark Richards wrote:
> One method is to set up a timer to peridoically flush any changes, close the 
> connection and then open it again.
> 
> A second method, and one which I use myself is every time a user selects to 
> do a new task in your application, for example if they change to a secondary 
> screen, or select an option from a menu, then the first cause of action 
> could be to flush any buffers, close the database connection, open it and 
> then launch the action the user has selected. This would ensure the changes 
> up to that point made by other users are displayed or calculated correctly.
> 
> hope that helps 
> 
>

Technical Details

Message-ID: <474e6de4$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news3.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<4749c64f$1@newsgroups.borland.com> <474be427$1@newsgroups.borland.com> <474ca07a@newsgroups.borland.com> <474d460b$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,227f63e8df0318bf
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 29 Nov 2007 08:44:42 +0100
From: Mario Sernicola <mariosernicola@libero.nospam.it>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Using Access database in a network with ADO
References: <4749c64f$1@newsgroups.borland.com> <474be427$1@newsgroups.borland.com> <474ca07a@newsgroups.borland.com> <474d460b$1@newsgroups.borland.com>
In-Reply-To: <474d460b$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87.19.248.72
Message-ID: <474e6de4$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196322276 87.19.248.72 (28 Nov 2007 23:44:36 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news3.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message