Re: Refresh data from Remote View

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Dale Clarkston" <dclarkston@xxxxxxxxxxx> schrieb im Newsbeitrag news:OWmIPcwVFHA.3764@xxxxxxxxxxxxxxxxxxxxxxx 
In VFP 6.0, when users add or edit records in remote views, other users on
the network can not see the changes. Atleast until they exit the application
and reenter it. The views are from Oracle 9 tables. Besides issuing a
Requery(), what can be done so that the users can see the updated data in
these tables?


Do you say Requery() does not work or do you just want to avoid it?
If the latter try
REFRESH([nRecords [, nRecordOffset]] [, cTableAlias | nWorkArea])


hth
-Stefan



--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
----------------------------------------------------------- 

.

Relevant Pages

  • Re: Preventing Additions or Edits ... need help
    ... issuing a REQUERY for one of the combobox controls in the 1st form. ... VISIBLE property of the form to TRUE so that the form appears when form ...
    (comp.databases.ms-access)
  • Re: limit TABLE to only one record
    ... without issuing any DDL statements. ... I'm guessing that a TABLE with one ... ID and DATA are both reserved words in Oracle. ...
    (comp.databases.oracle.server)
  • Re: OT: MySQL query: Order By
    ... Oracle are still, for example, issuing ... > Security patches maybe - bug tars definitely not. ... Sure - but when did you last come across a bug in Oracle after Oracle ... masse relative to the small amount of DBA effort actually involved - but ...
    (uk.rec.motorcycles)
  • Extra query on Oracle Catalog
    ... We developed some applications using Delphi 5 with ADOExpress ... and Oracle 9.0.2 (Note: the problem that I'm issuing is present on Oracle ... from ) we have in Oracle an extra query on catalog ...
    (borland.public.delphi.database.ado)
  • Re: Migrating dbf tables to SQL Server
    ... The same can be said for Express version of SQL Server, and I believe Oracle ... and then use a REQUERY() to fetch the data ...
    (microsoft.public.fox.programmer.exchange)