Greetings!

I have a table-buffered remote view (call it myview). A few edits, deletes,
and updates are performed on the buffered view.

Example:

Suppose the view originally contains records:
A
B
C

Then, C is deleted and D is added:
A
B
D

Now, SELECT * FROM myview
will result in a record set looking like:
A
B
C

Is there a way to manipulate the current buffer (containing A, B, and D)
with SQL SELECT?


Thanks!

Currently, until you do a TableUpdate() - no. You can use the "old" xBase Scan ... Endscan to process the buffered data. Note: According to an older newsletter by Ken Kevy (http://msdn.microsoft.com/vfoxpro/letters/01232004/), this will be one of VFP 9.0's enhancements.

Rick

"OE" <oeng (AT) remove (DOT) rogers.com> wrote