How to suppress a message shown while retrieving remote data from MSDE?

Hello everyone,

I have an apps that utilize MSDE as the backend database. It's been
running on my client for almost a year by now. Problem is, today my
client complained that the apps began to give a 'strange message'
sometimes. I went to their place and found that the message is something
like this: 'Please wait while executing remote data. Press ESC to
cancel'. The message shown in a wait...window. I assume that the message
was thrown out because VFP runtime consider that the query would take
some time to finish. But, it's a bit annoying. I mean, who would want to
cancel? And if they do press ESC, the apps would stop.
Question: Is there anyway to suppress the message -or better yet, to
replace the message with something friendlier (like progress bar) with
little or no change to the code?

TIA,
Willianto

Stefan
Mon Jun 28 14:37:58 CDT 2004

Hi Willianto,

Does Set Escape Off help?


hth
-Stefan

"Willianto" <willianto@remove-me.telkom-and-me.net> schrieb im Newsbeitrag
news:%23b8outTXEHA.3420@TK2MSFTNGP12.phx.gbl...
> Hello everyone,
>
> I have an apps that utilize MSDE as the backend database. It's been
> running on my client for almost a year by now. Problem is, today my
> client complained that the apps began to give a 'strange message'
> sometimes. I went to their place and found that the message is something
> like this: 'Please wait while executing remote data. Press ESC to
> cancel'. The message shown in a wait...window. I assume that the message
> was thrown out because VFP runtime consider that the query would take
> some time to finish. But, it's a bit annoying. I mean, who would want to
> cancel? And if they do press ESC, the apps would stop.
> Question: Is there anyway to suppress the message -or better yet, to
> replace the message with something friendlier (like progress bar) with
> little or no change to the code?
>
> TIA,
> Willianto
>
>

Gerben
Tue Jun 29 02:55:05 CDT 2004

Hi,

You can use SET NOTIFY OFF to supress the message.

Gerben Kessen


"Willianto" <willianto@remove-me.telkom-and-me.net> wrote in message
news:%23b8outTXEHA.3420@TK2MSFTNGP12.phx.gbl...
> Hello everyone,
>
> I have an apps that utilize MSDE as the backend database. It's been
> running on my client for almost a year by now. Problem is, today my
> client complained that the apps began to give a 'strange message'
> sometimes. I went to their place and found that the message is something
> like this: 'Please wait while executing remote data. Press ESC to
> cancel'. The message shown in a wait...window. I assume that the message
> was thrown out because VFP runtime consider that the query would take
> some time to finish. But, it's a bit annoying. I mean, who would want to
> cancel? And if they do press ESC, the apps would stop.
> Question: Is there anyway to suppress the message -or better yet, to
> replace the message with something friendlier (like progress bar) with
> little or no change to the code?
>
> TIA,
> Willianto
>
>

Willianto
Tue Jun 29 11:09:32 CDT 2004

Hi Gerben, Hi Stefen,

Thank you both. I put SET NOTIFY OFF and the message disappear. Btw, do
you know how to change the message to a friendlier message?

TIA,
Willianto

"Gerben Kessen" <gerben.kessen(@)wantit.nl> wrote in message
news:et8#$5aXEHA.644@tk2msftngp13.phx.gbl...
> Hi,
>
> You can use SET NOTIFY OFF to supress the message.
>
> Gerben Kessen
>
>
> "Willianto" <willianto@remove-me.telkom-and-me.net> wrote in message
> news:%23b8outTXEHA.3420@TK2MSFTNGP12.phx.gbl...
> > Hello everyone,
> >
> > I have an apps that utilize MSDE as the backend database. It's been
> > running on my client for almost a year by now. Problem is, today my
> > client complained that the apps began to give a 'strange message'
> > sometimes. I went to their place and found that the message is
something
> > like this: 'Please wait while executing remote data. Press ESC to
> > cancel'. The message shown in a wait...window. I assume that the
message
> > was thrown out because VFP runtime consider that the query would
take
> > some time to finish. But, it's a bit annoying. I mean, who would
want to
> > cancel? And if they do press ESC, the apps would stop.
> > Question: Is there anyway to suppress the message -or better yet, to
> > replace the message with something friendlier (like progress bar)
with
> > little or no change to the code?
> >
> > TIA,
> > Willianto
> >
> >
>
>

Gerben
Tue Jun 29 14:40:34 CDT 2004

SET NOTIFY OFF
WAIT WINDOW "Would you please be so kind to hit the Escape key..." NOWAIT

"YOUR SQL STUFF..."

WAIT CLEAR


Gerben Kessen


"Willianto" <willianto@remove-me.telkom-and-me.net> wrote in message
news:eSFLBEgXEHA.1888@TK2MSFTNGP11.phx.gbl...
> Hi Gerben, Hi Stefen,
>
> Thank you both. I put SET NOTIFY OFF and the message disappear. Btw, do
> you know how to change the message to a friendlier message?
>
> TIA,
> Willianto
>
> "Gerben Kessen" <gerben.kessen(@)wantit.nl> wrote in message
> news:et8#$5aXEHA.644@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > You can use SET NOTIFY OFF to supress the message.
> >
> > Gerben Kessen
> >
> >
> > "Willianto" <willianto@remove-me.telkom-and-me.net> wrote in message
> > news:%23b8outTXEHA.3420@TK2MSFTNGP12.phx.gbl...
> > > Hello everyone,
> > >
> > > I have an apps that utilize MSDE as the backend database. It's been
> > > running on my client for almost a year by now. Problem is, today my
> > > client complained that the apps began to give a 'strange message'
> > > sometimes. I went to their place and found that the message is
> something
> > > like this: 'Please wait while executing remote data. Press ESC to
> > > cancel'. The message shown in a wait...window. I assume that the
> message
> > > was thrown out because VFP runtime consider that the query would
> take
> > > some time to finish. But, it's a bit annoying. I mean, who would
> want to
> > > cancel? And if they do press ESC, the apps would stop.
> > > Question: Is there anyway to suppress the message -or better yet, to
> > > replace the message with something friendlier (like progress bar)
> with
> > > little or no change to the code?
> > >
> > > TIA,
> > > Willianto
> > >
> > >
> >
> >
>
>

Willianto
Tue Jun 29 19:47:00 CDT 2004

Hi Gerben,

> SET NOTIFY OFF
> WAIT WINDOW "Would you please be so kind to hit the Escape key..."
NOWAIT
>
> "YOUR SQL STUFF..."
>
> WAIT CLEAR

Oh well, very simple but didn't even cross my mind ;-)
Yet, I was hoping I could put something like the following once in my
main.prg:

SET NOTIFY _RemoteDelay TO "Would you please wait and KEEP YOUR HAND OFF
THE KEYBOARD"

or:
SET NOTIFY _RemoteDelay TO AutomaticProgressBar

Yes. I know. I was only dreaming ;-)
Thanks anyway! Appreciate your time :-)

Willianto.