Auto Refresh Query with Parameter

[MartinSchm]

Hello,

if I execute a query like:

Select * from Tabelle where Feld = '&Parameter'

I get a prompt asking me to enter "Parameter".
Everthing fine so far.

If I auto refresh the query the prompt pops up everytime the query is executed.

Is it possible to enter the prompt just one time ?

bye
Martin

 

[Marco Kalter]

This is currently not possible. It does make sense though, so I have added this to the list of enhancement requests.

 

[Robert_G]

It's possible to use your SQL Statement in a test window:

SELECT *
FROM   Tabelle
WHERE  Feld = :DeinFeld

There, you can set an intervall and it should work just fine. (In fact I've never tested it though... )

 

[Robert_G]

It works that way.

 

[Stew Stryker]

I'm running 6.0.3 and don't see any Auto Refresh option on my SQL Windows or description in Help. Sounds like a really cool feature. Do I have to do something to turn it on?

Thanks,

Stew

 

[Robert_G]

You should find a small icon in the lower left corner of each executeable Window (SQL, Test, Command,...) showing a sort of twisted arrow.
By clicking with right mouse button you can choose the intervall, left clicking will enable/disable the intervalled execution.
I really like it in the session list (on that window you'll find the button in the upper left corner).

 

[Stew Stryker]

DOH!

I've wander by that icon to look at the 2 status icons but never stopped long enough to get the hint popup.

Thanks,

Stew

p.s. If this is documented in Help, it needs some more keywords added, as I searched high and low and couldn't find it. Liked (auto-refresh, auto, refresh, etc)