Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Larry
Why are you recreating the view? Just change its parameters and requery. Recreating the view will force you to reassign the grid's controlsource etc.
HTH
>Hi -
>
>I have created a view which is being displayed in a readonly grid. I then have a button which forces a the view to be recreated (CREATE SQL VIEW), I then perform a Requery. Hoping that the the grid will be refreshed with the new view data. Its not.Why please?
>
>If I close the view then open it again it shows the new data there. I also checked the requery() return value, it is 1, so everything is working correctly just the refreshed data is not updating the active view. Can someone please advise.
>
>Thanks,
>
>Larry
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only