Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering
Message
From
01/02/2007 13:59:46
 
 
To
01/02/2007 13:55:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01191514
Message ID:
01191532
Views:
15
>>>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' )  && Enable row buffering.
>>>= CURSORSETPROP('Buffering',5, 'projects' )  && Enable row buffering.
>>>= CURSORSETPROP('Buffering',5, 'projectphases' )  && Enable row buffering.
>>>= CURSORSETPROP('Buffering',5, 'lineitemspecs' )  && Enable row buffering.
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform