Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving grid data back to original table
Message
From
09/10/1997 11:36:14
 
 
To
09/10/1997 11:26:55
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00053895
Message ID:
00053900
Views:
28
>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().
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform