>Hi all!
>
>I'm using a grid whose record source is a view to collect data. I'm trying to save the changes a user makes in column2 back to the original table by using code in the LostFocus method of the textbox under the column2.
>
>My code (which isn't working of course) looks like this (again, it's grid->column2->text1's LostFocus method):
>
>local lview, lswid, lver
>*the following 3 lines capture the current view record data to use
>* as a filter in the original table
>lview = this.parent.parent.recordsource
>lswid = &lview..software
>lver = &lview..version
>*select the original table, use a filter to access the correct
>* record and replace 'version' field with the value in the
>* current grid-column-textbox
>select software
>set filter to acode=caid and hwid=chwid and software="&lswid" and version="&lver"
>go top
>replace version with this.value
>
>Any clue what I'm doing wrong? Similar code is working for my combo boxes but for a 'simple' text box, this isn't working.
If you have a buffering on the view, you only have to do TABLEUPDATE().