Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting a table's record from a grid populated by a vie
Message
From
19/12/1997 12:14:40
Jeff Tucker
Mackinac Center For Public Policy
Midland, Michigan, United States
 
 
To
19/12/1997 10:41:04
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00067194
Message ID:
00067226
Views:
14
>>This should be easy.
>>
>>I have a grid which is populated by a view.
>>
>>I want the user to be able to remove a row from the grid by pressing a "Remove" button.
>>
>>Behind the scenes, the record should be marked as deleted in the table. Then the view should be requeried and the grid refreshed.
>>
>>I do not know where to start with this. How do I remove the current row? There must be an index to tell me which row is active when the remove button is pushed.
>>
>>Jeff
>
>Just put
>DELETE IN myview
>in your remove button.
>You'll then have to requery the view and refresh the form.
>And don't forget to have SET DELETED ON in the form.

Fantastic. Thanks Erik.

Jeff
Previous
Reply
Map
View

Click here to load this message in the networking platform