Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why can't I add!
Message
De
05/04/2001 09:33:54
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why can't I add!
Divers
Thread ID:
00492307
Message ID:
00492307
Vues:
55
I have a requisition form with a pageframe containing 3 pages. Each page has its own parameterized view for the objects contained on the page. There is a requisition header view (optimistic row buffering) that use the requisition # as its parameter and drives the other two views. The second view (requisition detail - optimistic table buffering) is a recordsource for a one column grid using a container class inside the grid for data entry. The third view (requisition account info - optimistic table buffering) is a recordsource for a two column grid on the third page for entering account distribution information. I can add a new record to all three views once the form inits, but if I edit the current requisition then cancel and try to add. I get "file is in use by another user" when attempting to add a record to the second view. This is done strictly in development mode and there are no other users accessing the same view. I even checked to see if the view was being opened twice in the data sessions window. It is not. The code I use to add a record to the second view is as follows:

SELECT vreq_detail
TABLEREVERT(.T.) Cleans the view buffer before requerying.
REQUERY("vreq_detail",ireqhdr_id) ireqhdr_id = 0, appended header record.

SELECT vreq_detail
APPEND BLANK

I've stepped through the code so I know the error occurs when I append the blank.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform