Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uncommitted changes in child view
Message
 
À
15/02/1999 08:38:34
Marco Beuk
Innovero Software Solutions
The Hague, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00187641
Message ID:
00187660
Vues:
22
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform