Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data changes only commited when app is closed
Message
From
16/03/2005 10:24:56
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996302
Message ID:
00996333
Views:
29
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform