Refresh data from Remote View

In VFP 6.0, when users add or edit records in remote views, other users on
the network can not see the changes. Atleast until they exit the application
and reenter it. The views are from Oracle 9 tables. Besides issuing a
Requery(), what can be done so that the users can see the updated data in
these tables?

Thanks for the help,
Dale

Stefan
Thu May 12 11:44:15 CDT 2005


"Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
news:OWmIPcwVFHA.3764@TK2MSFTNGP15.phx.gbl...
> In VFP 6.0, when users add or edit records in remote views, other users on
> the network can not see the changes. Atleast until they exit the application
> and reenter it. The views are from Oracle 9 tables. Besides issuing a
> Requery(), what can be done so that the users can see the updated data in
> these tables?

Do you say Requery() does not work or do you just want to avoid it?
If the latter try
REFRESH([nRecords [, nRecordOffset]] [, cTableAlias | nWorkArea])


hth
-Stefan



--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Dale
Thu May 12 12:00:23 CDT 2005

Stefan,

Thanks for the tip about Refresh(). I want to avoid using requery, because I
need to refresh 30,000+ records and requery takes to long to do that. Is
Refresh() quicker then requery? And in Help for Refresh it states that if
you leave out nRecords that it will only update one record, so how do i go
about refreshing the whole view? Is it as simple as doing a count right
before the refresh?

Thanks again for the help

"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:%23MS0EMxVFHA.2124@TK2MSFTNGP14.phx.gbl...
>
> "Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
> news:OWmIPcwVFHA.3764@TK2MSFTNGP15.phx.gbl...
> > In VFP 6.0, when users add or edit records in remote views, other users
on
> > the network can not see the changes. Atleast until they exit the
application
> > and reenter it. The views are from Oracle 9 tables. Besides issuing a
> > Requery(), what can be done so that the users can see the updated data
in
> > these tables?
>
> Do you say Requery() does not work or do you just want to avoid it?
> If the latter try
> REFRESH([nRecords [, nRecordOffset]] [, cTableAlias | nWorkArea])
>
>
> hth
> -Stefan
>
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>

Stefan
Thu May 12 12:16:02 CDT 2005

Hi Dale,

"Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
news:OWwnXQxVFHA.584@TK2MSFTNGP15.phx.gbl...
> Stefan,
>
> Thanks for the tip about Refresh(). I want to avoid using requery, because I
> need to refresh 30,000+ records and requery takes to long to do that. Is
> Refresh() quicker then requery?

Yes, but only because of the option to refresh just one or a few rows.
If you want to get the entire view, I'd say there is no alternative for Requery()
How about "parameterizing" the view and display only a small subset at a time?


-Stefan



--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Dale
Thu May 12 12:18:19 CDT 2005

Stefan,

Thanks for the help. I was thinking that requery was my only option, but I
just wanted to make 100% sure. Looks like the users will just have to put up
with the requeries, because it's not a priority to redo the application,
which is what it will take to parameterize the views correctly


"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:OqDzHXxVFHA.1796@TK2MSFTNGP15.phx.gbl...
> Hi Dale,
>
> "Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
> news:OWwnXQxVFHA.584@TK2MSFTNGP15.phx.gbl...
> > Stefan,
> >
> > Thanks for the tip about Refresh(). I want to avoid using requery,
because I
> > need to refresh 30,000+ records and requery takes to long to do that. Is
> > Refresh() quicker then requery?
>
> Yes, but only because of the option to refresh just one or a few rows.
> If you want to get the entire view, I'd say there is no alternative for
Requery()
> How about "parameterizing" the view and display only a small subset at a
time?
>
>
> -Stefan
>
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>

Dale
Fri May 13 09:02:37 CDT 2005

One other question since I am on the subject, I am using an ODBC with remote
views in my application. Can I use ADO with a connection string to Oracle,
instead of ODBC and if so is the connection string all I would have to
modify in my application?
"Dale Clarkston" <dclarkston@lcounty.com> wrote in message
news:ONoCZaxVFHA.1384@TK2MSFTNGP09.phx.gbl...
> Stefan,
>
> Thanks for the help. I was thinking that requery was my only option, but I
> just wanted to make 100% sure. Looks like the users will just have to put
up
> with the requeries, because it's not a priority to redo the application,
> which is what it will take to parameterize the views correctly
>
>
> "Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
> news:OqDzHXxVFHA.1796@TK2MSFTNGP15.phx.gbl...
> > Hi Dale,
> >
> > "Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
> > news:OWwnXQxVFHA.584@TK2MSFTNGP15.phx.gbl...
> > > Stefan,
> > >
> > > Thanks for the tip about Refresh(). I want to avoid using requery,
> because I
> > > need to refresh 30,000+ records and requery takes to long to do that.
Is
> > > Refresh() quicker then requery?
> >
> > Yes, but only because of the option to refresh just one or a few rows.
> > If you want to get the entire view, I'd say there is no alternative for
> Requery()
> > How about "parameterizing" the view and display only a small subset at a
> time?
> >
> >
> > -Stefan
> >
> >
> >
> > --
> > |\_/| ------ ProLib - programmers liberty -----------------
> > (.. ) Our MVPs and MCPs make the Fox run....
> > - / See us at www.prolib.de or www.AFPages.de
> > -----------------------------------------------------------
> >
>
>

Stefan
Sun May 15 02:52:07 CDT 2005


"Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
news:uGDmsR8VFHA.612@TK2MSFTNGP12.phx.gbl...
> One other question since I am on the subject, I am using an ODBC with remote
> views in my application. Can I use ADO with a connection string to Oracle,
> instead of ODBC and if so is the connection string all I would have to
> modify in my application?

No, Remote Views don't work with OleDB / ADO.
ADO is quite different, i.e. dealing with data objects via COM instead
of VFP cursors. Since Vfp8 you can use the Cursor Adapter class to do
so but that would mean even more redesign than parameterizing the existing
views. As for the performance question, OleDB itself may be slightly
quicker than ODBC but the required ADO overhead slows it down again.


-Stefan


--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------