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 15:36:57
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
25/05/2001 14:11:28
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00511643
Message ID:
00511687
Views:
17
I've tried creating a second view of the first view with the intent of putting table level buffering on it instead of row, but it keeps returning all the records from the base table instead of those that are in the first view. The first view is based on a table and has the social security number as its criteria, so I thought that the second view, with no criteria, would pull only the records contained in the filtered first view, not all the records as if there was no criteria at all. If I need to have criteria on the second view, then I can't use it for this purpose. What fundamental understanding am I lacking on this? Thanks!

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform