Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New records not showing up in table that's been USED AGA
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00246924
Message ID:
00247052
Views:
23
>>>Does a buffered USED AGAIN table need to be requeried for new records appended to the buffered parent table to show up in the USED AGAIN table?
>>
>>Have those buffered changes been tableupdated?
>
>I need the records to show up in the USED AGAIN table before they are tableupdated in the parent table!

You're in trouble, since until the table is updated from the buffer, the data in the buffer is available only to the working instance of the data. The buffer applies to the work area; multiple work areas that have the same file opened aren't able to see changes in another instance's buffer until they're committed to the table and the instance is requeried.

If that weren't the case, a TABLEUPDATE() of one instance's buffers would commit the data from all instances of that table in use at the same time, with potentially disasterous consequences. TABLEUPDATE() scopes to a single USE statement.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform