Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Editing a Field Used as View Filter Criteria
Message
From
25/05/2001 14:11:28
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Editing a Field Used as View Filter Criteria
Miscellaneous
Thread ID:
00511643
Message ID:
00511643
Views:
52
The nature of the beast on this application requires me to allow editing of a field that is used as the selection criteria for a grid's view. For example, on a grid on a form the user selects a record and second form appears with a grid. This second grid is based on a view using the social security number from the selected record as it's criteria. The point of this second form and grid is to allow editing of the social security number. It is not allow anywhere else in the system, but the user needs to be able to do it from time to time. The problem I have is after the field is changed and Save is selected, the subsequent TableUpdate causes the view to display all records except the one that was changed. I understand why this is so, but is there a logical way to save the record and have it appear in the grid at the same time? I'm thinking something about two views, one based on the other, but it's getting a bit murky the more I try to think about it... Any help is greatly appreciated... Thanks!

Regards, Renoir
Next
Reply
Map
View

Click here to load this message in the networking platform