General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Next
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