>>>I have a form with 5 tables in the dataenvironment. The buffermodeoverride is set to 1 for all of the tables.
>>>
>>>The form's init contains:
>>>
>>>set multilocks on
>>>= CURSORSETPROP('Buffering',5, 'biditems' )
>>>= CURSORSETPROP('Buffering',5, 'projects' )
>>>= CURSORSETPROP('Buffering',5, 'projectphases' )
>>>= CURSORSETPROP('Buffering',5, 'lineitemspecs' )
>>>dodefault()
>>>
>>>The form's buffermode = 2
>>>
>>>The form has a pageframe and the pageframe contains a grid.
>>>The grid's recordsource is set
>>>
>>>thisform.df_tabs1.df_page1.grdBiditems.RecordSource = ;
>>>"select * from biditems " + ;
>>>" inner join lineitemspecs " + ;
>>>" on biditems.lineitemid = lineitemspecs.lineitemid " + ;
>>>" where biditems.projectphaseid = val(this.value) " + ;
>>>" into cursor crsTemp readwrite"
>>>
>>>The grid's AfterRowColChange contains
>>>LPARAMETERS nColIndex
>>>
>>>=tableupdate(0,.t.,"biditems")
>>>
>>>
>>>It all seems to work except the edits made in the grid are not being saved back to the biditems table. What am I missing?
>>
>>You miss couple things. The way you set it, changes will be definitely saved to the cursor, but there is no reason why should they go to the table. I guess that you want to use local view (buffered) for your grid recordsource. This view (parameterized) will be based on biditems table.
>
>Thanks for your reply. How would I change it to a local view buffered?
You can either use Local View Designer (under Databases tab in Project Window) or use Create SQL View command. The first way would be more appropriate to start with.
Please, note that this is not the only way to achieve this functionality, though the most popular.
Edward Pikman
Independent Consultant