Roy,

> I'm missing something here. How do I select a single line to execute? Is this another one for the hidden features list

When you click into the gutter at the left, a green icon will appear and
select this line for execution. (Screenshot attached)

Uli

Uli


I'd onny noticed those in scripts and I assumed they were breakpoints, on my screen the things are so small I had to take my glasses off and get up close and dirty to see that the symbol was now "play" rather than "pause"

Thanks

Roy Lambert

Tim

>In case you're wondering, it *has* to be this way because that's how selected statements work in the editor. Imagine a green selection arrow next to a line that includes two statements with a terminator between them. Which line is selected for execution ?

Now Uli has shown me what to look at I can answer the question, and its obvious really - both of them

Roy

Roy,

<< I'd onny noticed those in scripts and I assumed they were breakpoints, >>

Breakpoints in scripts are orange and contain a pause symbol.

Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Now Uli has shown me what to look at I can answer the question, and its obvious really - both of them >>

Both of them, or one and a half of them ?

SELECT * FROM MyTable !  SELECT *
FROM My Table !

Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< I'd onny noticed those in scripts and I assumed they were breakpoints, >>
>
>Breakpoints in scripts are orange and contain a pause symbol.

Two points here:

1. refer back to my comment about size
2. much more significant - people who assign colours a significance often forget about the large minority of the population that is colour blind. The most common form is red - green - brown colour blindness and even that occurs in different intensities. All this leads up to the point that for me the two colours for the breakpoint and selected indicators are one and the same

Roy Lambert

Tim

>Both of them, or one and a half of them ?

>SELECT * FROM MyTable ! SELECT *
>FROM My Table !

I like this game - OK what are you going to execute

select
_Name,
_id
from
companies

If I select ANY one of the physical lines making up the statement then the whole statement is selected. SO - add in a new suggestion that selection should select all of any statement that is partially implemented on a selected physical line. IE both of the statements would have been selected and thus both executed.

Roy Lambert

Roy,

<< If I select ANY one of the physical lines making up the statement then the whole statement is selected. >>

Correct.  None of the lines contain a ! statement terminator, so EDB assumes that the entire set of SQL is one statement.

It *is* actually consistent, as much as you want to believe otherwise.

Tim Young
Elevate Software
www.elevatesoft.com