General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for your reply Nick.
I was hoping that there was a way use the view.
Marco
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only