Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uncommitted changes in child view
Message
From
16/02/1999 02:53:37
Marco Beuk
Innovero Software Solutions
The Hague, Netherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00187641
Message ID:
00187933
Views:
19
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
Map
View

Click here to load this message in the networking platform