Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement