Home > Archive > FoxPro Help and Support > May 2005 > Refreshing a Grid polulated from a View









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Refreshing a Grid polulated from a View
Barley Man

2005-05-12, 7:24 am

I have a form with a grid created from a View. (Created the view, then
created the form and added the View to the data environment. I then created
the grid by dragging the view from the data environment onto the form).

It all works well.

I now need to add new values to the original table from which the view was
'viewed'. I can create those new records and can view the newly created
records when I close and re-open that form, however, I want to 'refresh' the
grid and the content of the view each time that I add a new record on that
form. How do I 'refresh' (recreate?) the view and how do I refresh the grid
containing that changed 'view'?

ian
Eric den Doop

2005-05-12, 7:24 am

Take a look at the REQUERY() function.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:62502D83-F9DC-4475-A561- A624E8A07421@microso
ft.com...
>I have a form with a grid created from a View. (Created the view, then
> created the form and added the View to the data environment. I then
> created
> the grid by dragging the view from the data environment onto the form).
>
> It all works well.
>
> I now need to add new values to the original table from which the view was
> 'viewed'. I can create those new records and can view the newly created
> records when I close and re-open that form, however, I want to 'refresh'
> the
> grid and the content of the view each time that I add a new record on that
> form. How do I 'refresh' (recreate?) the view and how do I refresh the
> grid
> containing that changed 'view'?
>
> ian



Barley Man

2005-05-12, 7:24 am

Thanks eric

"Eric den Doop" wrote:

> Take a look at the REQUERY() function.
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
> "Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
> news:62502D83-F9DC-4475-A561- A624E8A07421@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com