|
Home > Archive > Visual FoxPro SQL Queries > January 2006 > Update Single Record From SQL 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 |
Update Single Record From SQL View
|
|
| Andy Trezise 2006-01-06, 9:26 am |
| Hi
I am using a VIEW to return all the records from a remote SQL table and then
populating a simple grid.
I then allow the user to select one of the rows from the grid and update the
information in another form which uses its own private datasession.
How can I make the changes that the user makes to this single record visible
on the calling form without issuing 'REQUERY' which can take quite a few
seconds?
| |
| Stefan Wuebbe 2006-01-06, 9:26 am |
|
"Andy Trezise" <andy@work.com> schrieb im Newsbeitrag
news:O0rz3dsEGHA.1816@TK2MSFTNGP11.phx.gbl...
> Hi
>
> I am using a VIEW to return all the records from a remote SQL table and then
> populating a simple grid.
>
> I then allow the user to select one of the rows from the grid and update the
> information in another form which uses its own private datasession.
>
> How can I make the changes that the user makes to this single record visible on the
> calling form without issuing 'REQUERY' which can take quite a few seconds?
Hi, Try Refresh(1, 0, 'yourView')
hth
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------
| |
| Andy Trezise 2006-01-06, 1:24 pm |
| thank you very much
"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:%23LmGAmsEGHA.2040@TK2MSFTNGP14.phx.gbl...
>
> "Andy Trezise" <andy@work.com> schrieb im Newsbeitrag
> news:O0rz3dsEGHA.1816@TK2MSFTNGP11.phx.gbl...
>
> Hi, Try Refresh(1, 0, 'yourView')
>
>
> hth
> -Stefan
>
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>
|
|
|
|
|