Information générale
Titre:
Updating cursors / buffering
Hi
Here is a general question about buffering.
Scenario: I have a form and several tables in the data environment of the form. The buffering mode is set to 5 (optimistic table buffering)
Lets say my form is a customer form. I have a grid in the form which shows all the phone numbers of the customer. The record source for this grid is an SQL statement that acts on 3 other tables. This grid is read only. To add a new phone number I run a modal form to get the phone number, extension etc. Once I have the new phone info, in my initial form, I add records to the corresponding tables (phone, extension etc) and rerun the SQL query that is the recordsource of my readonly grid. The grid (cursor of the SQL query) does not pick up the newly added phone number until I do a save in my current form, thus executing tableupdate on all the tables in the data environment. I would like for the grid cursor to pick up the new phone numbers (from the buffered data) even before I do tableupdate. Is this not possible in VFP or am I missing something?
Thanx for your help
Gnana
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