Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted Records from View Still Show up in Grid
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00655898
Message ID:
00655979
Views:
23
Aaron,

If you are buffering the TableA you need to issue a TableUpdate() to commit the changes (like the delete). Then you need to Requery( "ViewAB" ) and call the grid.Refresh()

>I have a most perplexing problem wich is driving me insane
>
>I have 2 tables A and B
>
>I create a view AB joining the two tables
>
>If I delete a Record from Table A and Browse Table A or the View AB the record is gone (set deleted on) and is the behavior i desire
>
>If I use the view in a grid the deleted records still show up - problem
>
>I concidered using a cursor to popluate the grid - works but I can only have one index which is a problem (header sorting/etc.)
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform