Board index » delphi » Network D4/Paradox application - When using TTable.Refresh ?

Network D4/Paradox application - When using TTable.Refresh ?

To ensure that modifications made by others network stations are seen on the
current station you need to call TTable.refresh.

The question is when it's really required ?

Before FindKey ?
Before FindNearest ?
Before GotoKey ?
Before CancelRange ?
Before SetRange ?
Before Locate ?
...

Jean-Luc FIQUET
j...@match-eurosoft.com

begin 666 FIQUET JEAN LUC.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DQ50SM&25%5150@2D5!3@T*
M1DXZ1DE15454($I%04X@3%5##0I%34%)3#M04D5&.TE.5$523D54.FIL9D!M
M871C:"UE=7)O<V]F="YC;VT-"E)%5CHQ.3DY,#8P,U0Q-C,X-31:#0I%3D0Z
'5D-!4D0-"@``
`
end

 

Re:Network D4/Paradox application - When using TTable.Refresh ?


Quote
>To ensure that modifications made by others network stations are seen on the
>current station you need to call TTable.refresh.

>The question is when it's really required ?

>Before FindKey ?
>Before FindNearest ?
>Before GotoKey ?
>Before CancelRange ?
>Before SetRange ?
>Before Locate ?

None of these.  You need to call Refresh after you remove a filter.  And you
need to call refresh to get the value of the current record (or records if
multiple records are displayed)

Putting a record into Edit will refresh that record.   Scrolling the table
cursor will refetch any record that come into view.

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

Re:Network D4/Paradox application - When using TTable.Refresh ?


Hi Brian, i don't agree with you, if tou make a simple network test, you
will conclude that :
To see other users' modifications, you absolutely need to call Table.Refresh
:
- Before FindKey
- Before FindNearest
- Before GotoKey
- Before CancelRange
- Before SetRange
- Before Locate

Exemple:  if you have a  TTable open on user A and a user B insert an enreg
'X' in the Table, if user A call TTable.FindKey(['X']) wihtout calling
Refresh the result is FALSE. Idem with FindNearest, GotoKey...

Is there a better methode ?

----- Message d'origine -----
De : Brian Bushay TeamB <BBus...@Nmpls.com>
Groupes de discussion : borland.public.delphi.database.desktop
Envoy : vendredi 4 juin 1999 06:08
Objet : Re: Network D4/Paradox application - When using TTable.Refresh ?

Quote
> >To ensure that modifications made by others network stations are seen on
the
> >current station you need to call TTable.refresh.

> >The question is when it's really required ?

> >Before FindKey ?
> >Before FindNearest ?
> >Before GotoKey ?
> >Before CancelRange ?
> >Before SetRange ?
> >Before Locate ?

> None of these.  You need to call Refresh after you remove a filter.  And
you
> need to call refresh to get the value of the current record (or records if
> multiple records are displayed)

> Putting a record into Edit will refresh that record.   Scrolling the table
> cursor will refetch any record that come into view.

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

begin 666 FIQUET JEAN LUC.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DQ50SM&25%5150@2D5!3@T*
M1DXZ1DE15454($I%04X@3%5##0I%34%)3#M04D5&.TE.5$523D54.FIL9D!M
M871C:"UE=7)O<V]F="YC;VT-"E)%5CHQ.3DY,#8P-%0P-S4Q,SE:#0I%3D0Z
'5D-!4D0-"@``
`
end

Re:Network D4/Paradox application - When using TTable.Refresh ?


Quote
>Exemple:  if you have a  TTable open on user A and a user B insert an enreg
>'X' in the Table, if user A call TTable.FindKey(['X']) wihtout calling
>Refresh the result is FALSE. Idem with FindNearest, GotoKey...

You may be right.  I was thinking in terms of record refresh but if the key
value has changed then you need a current index and BDE probably has the index
cached.  

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

Other Threads