>Hi everybody,
>
>I have some problems with buffered views.
>During a 'edit'-session I need to open a second view which is based on information of a allready opened first view. Uncommitted changes in the first view are not available in the second view. Only the original data is there.
>
>Somehow this seems logical but it's not what I want. Is there a simple solution for this one.
>
>Thanks in advance,
>Marco
Marco, VFP actually requires the underlying table, and since the changes are not committed you will not get them. COPY TO will copy the actual uncommitted changes to a table, but, if you want the cursor, not a table created, you probably can use a workaround like this:
**CATEGS table contains some categories info
**lv_categs is the local view with the table buffering
=AFIELDS(laCategs, "CATEGS")
CREATE cursor tmp_categs from array laCategs
SELECT lv_categs
COPY to array la_lv_categs
SELECT tmp_categs
APPEND from array la_lv_categs
HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison