Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data changes only commited when app is closed
Message
De
16/03/2005 10:24:56
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00996302
Message ID:
00996333
Vues:
28
>Hi All,
>
>We have an intermittent problem when updating data using the REPLACE command on two tables on the first machine. The data is saved but is not updated when looking at the data on the second machine until the application is closed on the first.
>
>We then tried specifying UNLOCK ALL after the REPLACE commands but the problem just evolved to either one of the table's data being displayed on the second pc correctly.
>
>I need to mention that the data was being viewed on the second pc using the BROWSE command after each REPLACE command on the first pc. We do not use buffering, transactions or multilocks on the tables. And the REPLACE is executed on a single record, locating by using SEEK, and using an UPDATE statement executes very slowly as the size of the tables get quite large.
>
>Any help will be greatly appreciated.
>
>Thanks,
>Jeun

Jeun,
I see changes immediately. Probably your browse needs refresh (see set refresh). Also you might try:
select * from myTable
after each replace on first computer.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform