how do u refresh query?  
Author Message
pampatipraveen





PostPosted: Mon Nov 01 19:08:53 CST 2004 Top

SQL Server Developer >> how do u refresh query?

Hi All,

I am doing the following ...but it doesn't work unless I stop the
query...and at that time there are a zillion grids :(

Is there a way to clear the Grids and just refresh it?

WHILE (1=1)
BEGIN
SELECT * from statusreport;
--- DISPLAY NOW ---
WAITFOR DELAY '0:00:01';
END

Regards,
Mekim

SQL Server139  
 
 
David





PostPosted: Mon Nov 01 19:08:53 CST 2004 Top

SQL Server Developer >> how do u refresh query?
> Hi All,
>
> I am doing the following ...but it doesn't work unless I stop the
> query...and at that time there are a zillion grids :(
>
> Is there a way to clear the Grids and just refresh it?
>
> WHILE (1=1)
> BEGIN
> SELECT * from statusreport;
> --- DISPLAY NOW ---
> WAITFOR DELAY '0:00:01';
> END
>
> Regards,
> Mekim

Refresh a query from what application?

--
David Gugick
Imceda Software
www.imceda.com
 
 
mekim





PostPosted: Mon Nov 01 19:19:01 CST 2004 Top

SQL Server Developer >> how do u refresh query? sorry David 'bout that!...sometimes I assume people can c the screen I'm
working on...I guess I don't have as much spyware as I thought :-)

->Query Analyser

I'm trying to 'view' a view that is updated every second with changing figures




> Hi All,
>
> I am doing the following ...but it doesn't work unless I stop the
> query...and at that time there are a zillion grids :(
>
> Is there a way to clear the Grids and just refresh it?
>
> WHILE (1=1)
> BEGIN
> SELECT * from statusreport;
> --- DISPLAY NOW ---
> WAITFOR DELAY '0:00:01';
> END
>
> Regards,
> Mekim
 
 
mekim





PostPosted: Mon Nov 01 19:20:01 CST 2004 Top

SQL Server Developer >> how do u refresh query? (grr..error saving...so there may be dups in the posting)
sorry David 'bout that!...sometimes I assume people can c the screen I'm
working on...I guess I don't have as much spyware as I thought :-)

->Query Analyser

I'm trying to 'view' a view that is updated every second with changing figures




> Hi All,
>
> I am doing the following ...but it doesn't work unless I stop the
> query...and at that time there are a zillion grids :(
>
> Is there a way to clear the Grids and just refresh it?
>
> WHILE (1=1)
> BEGIN
> SELECT * from statusreport;
> --- DISPLAY NOW ---
> WAITFOR DELAY '0:00:01';
> END
>
> Regards,
> Mekim
 
 
mekim





PostPosted: Mon Nov 01 19:19:02 CST 2004 Top

SQL Server Developer >> how do u refresh query? sorry David 'bout that!...sometimes I assume people can c the screen I'm
working on...I guess I don't have as much spyware as I thought :-)

->Query Analyser

I'm trying to 'view' a view that is updated every second with changing figures




> Hi All,
>
> I am doing the following ...but it doesn't work unless I stop the
> query...and at that time there are a zillion grids :(
>
> Is there a way to clear the Grids and just refresh it?
>
> WHILE (1=1)
> BEGIN
> SELECT * from statusreport;
> --- DISPLAY NOW ---
> WAITFOR DELAY '0:00:01';
> END
>
> Regards,
> Mekim
 
 
David





PostPosted: Tue Nov 02 01:23:43 CST 2004 Top

SQL Server Developer >> how do u refresh query?
> (grr..error saving...so there may be dups in the posting)
> sorry David 'bout that!...sometimes I assume people can c the screen
> I'm working on...I guess I don't have as much spyware as I thought :-)
>
> ->Query Analyser
>
> I'm trying to 'view' a view that is updated every second with
> changing figures
>
>

>
>> Hi All,
>>
>> I am doing the following ...but it doesn't work unless I stop the
>> query...and at that time there are a zillion grids :(
>>
>> Is there a way to clear the Grids and just refresh it?
>>
>> WHILE (1=1)
>> BEGIN
>> SELECT * from statusreport;
>> --- DISPLAY NOW ---
>> WAITFOR DELAY '0:00:01';
>> END
>>
>> Regards,
>> Mekim

Yes, but where are you viewing this information (if those were
screenshots you posted, they did not come through). Are you using a
custom application? QA? SQL EM?

--
David Gugick
Imceda Software
www.imceda.com

 
 
Tibor





PostPosted: Tue Nov 02 01:31:10 CST 2004 Top

SQL Server Developer >> how do u refresh query? The grid isn't populated until the batch has finished executed. You can do this to text, but you
will get several resultsets back. Short answer is that Query Analyzer is not the right application
for this, there's no timer option in Query Analyzer...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/




> (grr..error saving...so there may be dups in the posting)
> sorry David 'bout that!...sometimes I assume people can c the screen I'm
> working on...I guess I don't have as much spyware as I thought :-)
>
> ->Query Analyser
>
> I'm trying to 'view' a view that is updated every second with changing figures
>
>

>
> > Hi All,
> >
> > I am doing the following ...but it doesn't work unless I stop the
> > query...and at that time there are a zillion grids :(
> >
> > Is there a way to clear the Grids and just refresh it?
> >
> > WHILE (1=1)
> > BEGIN
> > SELECT * from statusreport;
> > --- DISPLAY NOW ---
> > WAITFOR DELAY '0:00:01';
> > END
> >
> > Regards,
> > Mekim


 
 
mekim





PostPosted: Tue Nov 02 06:06:02 CST 2004 Top

SQL Server Developer >> how do u refresh query? Hi Tibor,

grrr...not what i wanted to hear...but thx just the same :-)

I was trying not to write a "timer" app..but I suppose that's the user
friendly sql way :-)

Regards
Mekim



> The grid isn't populated until the batch has finished executed. You can do this to text, but you
> will get several resultsets back. Short answer is that Query Analyzer is not the right application
> for this, there's no timer option in Query Analyzer...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>


> > (grr..error saving...so there may be dups in the posting)
> > sorry David 'bout that!...sometimes I assume people can c the screen I'm
> > working on...I guess I don't have as much spyware as I thought :-)
> >
> > ->Query Analyser
> >
> > I'm trying to 'view' a view that is updated every second with changing figures
> >
> >

> >
> > > Hi All,
> > >
> > > I am doing the following ...but it doesn't work unless I stop the
> > > query...and at that time there are a zillion grids :(
> > >
> > > Is there a way to clear the Grids and just refresh it?
> > >
> > > WHILE (1=1)
> > > BEGIN
> > > SELECT * from statusreport;
> > > --- DISPLAY NOW ---
> > > WAITFOR DELAY '0:00:01';
> > > END
> > >
> > > Regards,
> > > Mekim
>
>
>
 
 
mekim





PostPosted: Tue Nov 02 06:07:03 CST 2004 Top

SQL Server Developer >> how do u refresh query? Hi David,


answer...i suppose that's not the case. Simply enough to create...but still

Regards,
Mekim




> > (grr..error saving...so there may be dups in the posting)
> > sorry David 'bout that!...sometimes I assume people can c the screen
> > I'm working on...I guess I don't have as much spyware as I thought :-)
> >
> > ->Query Analyser
> >
> > I'm trying to 'view' a view that is updated every second with
> > changing figures
> >
> >

> >
> >> Hi All,
> >>
> >> I am doing the following ...but it doesn't work unless I stop the
> >> query...and at that time there are a zillion grids :(
> >>
> >> Is there a way to clear the Grids and just refresh it?
> >>
> >> WHILE (1=1)
> >> BEGIN
> >> SELECT * from statusreport;
> >> --- DISPLAY NOW ---
> >> WAITFOR DELAY '0:00:01';
> >> END
> >>
> >> Regards,
> >> Mekim
>
> Yes, but where are you viewing this information (if those were
> screenshots you posted, they did not come through). Are you using a
> custom application? QA? SQL EM?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
>