Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread EDB Manager - auto refresh
Wed, May 16 2007 7:05 PMPermanent Link

"Royke"
Is there any technical reason why any Execute SQL would not automatically be
followed by a Refresh?

A 'Clear SQL' might be useful.

RJ

Wed, May 16 2007 7:07 PMPermanent Link

"Royke"
"Royke" <royke@canada.com> wrote in message
news:CF0799A3-E180-4368-B21D-D92A91D439AD@news.elevatesoft.com...
>
> A 'Clear SQL' might be useful.
>
> RJ

Please don't ask me how I could have missed 'New SQL'.

RJ


Thu, May 17 2007 1:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Is there any technical reason why any Execute SQL would not automatically
be followed by a Refresh? >>

I'm not sure what you mean.  Are you asking why result sets aren't
automatically refreshed ?  Is the result set sensitive (live) or insensitive
(canned) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, May 18 2007 1:58 AMPermanent Link

"Royke"
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:BD84955B-B820-4521-9361-38627CB880F8@news.elevatesoft.com...
> Roy,
>
> << Is there any technical reason why any Execute SQL would not
> automatically be followed by a Refresh? >>
>
> I'm not sure what you mean.  Are you asking why result sets aren't
> automatically refreshed ?  Is the result set sensitive (live) or
> insensitive (canned) ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com

Let me look up what this means ...

This is only about the EDB Manager, when (for example) using ExecSQL to
create a new table in a database. Why do I have to Refresh to see it show
up?

Roy

Fri, May 18 2007 3:41 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< This is only about the EDB Manager, when (for example) using ExecSQL to
create a new table in a database. Why do I have to Refresh to see it show
up? >>

Ahh, okay, now I know what you're talking about.  The EDB Manager only
reflects DDL operations done interactively using the dialogs.  Anything else
requires a refresh.  The reasoning behind this is performance.  Sometimes a
user may want to perform a series of DDL statements before refreshing.  This
will be even more so the case once script support is included in EDB.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image