Board index » delphi » Data Refresh design problem

Data Refresh design problem

Hi,
i have an application with 23 tables and about 22 queries.
My app is a fsMDIForm with its childs. The childs are pre-designed and
created and destroyed by request.There are 5 users. It is D3 with Paradox.
NetDir and LocalShare are fines.

How can i do to guarantee that all the users see the actual information ?
Should i make a table refresh everytime i open a form ? Or on AfterScroll of
a table ?
Is it heavy to make a Refresh to all the tables at once, each time a form is
open ?

Is there any way i can refresh the TDatabase ? so that all the tables would
be too ?

i think you understand my question. Simultaneous users, data beeing
changed...If Mary changes a code and posts it, i would like john to see it
as soon as possible.

Thanks,

Pedro MG
----------------------------------------------------------------------------
-------
TQuadrado - Empresa de Servi?os Informticos, Lda.
R. da Constitui??o, 47, 3o
4200-197 Porto
PORTUGAL
Tel: +351.2.5503992 / 8
Fax: +351.2.5503979
t...@esoterica.pt
t...@esoterica.pt
----------------------------------------------------------------------------
-------

 

Re:Data Refresh design problem


Refresh is called automatically when you edit a record so you will always be
working with the latest data when making changes. Other than that you are on
your own. You can call Refresh periodically from a timer but do not Refresh
a table unless it is in Browse mode because the call to Refresh will post
the current record. The other alternative, as you have suggested, is to call
Refresh from some other event. The tradeoff is that calling Refresh
generates network traffic so you do not want to do it too often with too
many users or performance will suffer.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

Re:Data Refresh design problem


Hi, Pedro.

I make this that.

I have one timer. I set it to call on every 3 sec. I check every table and
query is not edit or insert mode (of course she must be open) and call
refresh or close open.

Gratitude.

ps. I'm sorry for my very bad English.
--
Petio Tonev
pto...@iname.com
www.i.am/ptonev

Re:Data Refresh design problem


Quote
>How can i do to guarantee that all the users see the actual information ?
>Should i make a table refresh everytime i open a form ? Or on AfterScroll of
>a table ?

If the tables are in a data module instead of on the form then you should call
Refresh when opening the form.  BDE will refresh data when you scroll a new
record on to the screen and when you edit the current record.

Quote
>Is it heavy to make a Refresh to all the tables at once, each time a form is
>open ?

Less impact then opening the tables

Quote
>Is there any way i can refresh the TDatabase ? so that all the tables would
>be too ?

No.

Quote

>i think you understand my question. Simultaneous users, data beeing
>changed...If Mary changes a code and posts it, i would like john to see it
>as soon as possible.

You could put a timer on the form and refresh the tables in the time.
set the timer interval to what ever you think you need.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads