Eclipse Community Forums: DTP » SQL Editor multiple select statements

Help

Home

Home » Eclipse Projects » DTP » SQL Editor multiple select statements

Show: Today's Messages :: Show Polls :: Message Navigator

SQL Editor multiple select statements [message #40430]

Mon, 07 January 2008 21:21

Francine Mising name

Messages: 21
Registered: July 2009

Junior Member

We used to have the multiple selects run as a single SQL statement and the
result sets are displayed correctly, but multiple DDL statements fail. We
added code to our SQLService to perform the splitSQL, to allow for groups
to run multiple SQL statements individually. They run fine but we notice
that with multiple select statements, the result sets are no longer
displayed in the Results View. We only get a status update.

Should the split prevent result sets from being displayed? Is this a bug
or further implementation that we need to do for our database support?

thank you for your response,
Francine

Report message to a moderator

Re: SQL Editor multiple select statements [message #45540 is a reply to message #40430]

Mon, 16 June 2008 02:48

Eclipse User

Originally posted by: hui.cao.sybase.ocm

Francine,
That sounds strange: splitSQL should have no effect on what gets
displayed in Results View. Was it possible that you didn't expand the
execution result group? Please let me how it goes now, thanks.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Francine" <francine.grimmer@teradata.com> wrote in message
news:6f44ad658764d4f5fed224217ad480fb$1@www.eclipse.org...
> We used to have the multiple selects run as a single SQL statement and the
> result sets are displayed correctly, but multiple DDL statements fail. We
> added code to our SQLService to perform the splitSQL, to allow for groups
> to run multiple SQL statements individually. They run fine but we notice
> that with multiple select statements, the result sets are no longer
> displayed in the Results View. We only get a status update.
>
> Should the split prevent result sets from being displayed? Is this a bug
> or further implementation that we need to do for our database support?
> thank you for your response,
> Francine
>

Report message to a moderator

Re: SQL Editor multiple select statements [message #591496 is a reply to message #40430]

Mon, 16 June 2008 02:48

Hui Cao

Messages: 29
Registered: July 2009

Junior Member

Francine,
That sounds strange: splitSQL should have no effect on what gets
displayed in Results View. Was it possible that you didn't expand the
execution result group? Please let me how it goes now, thanks.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Francine" <francine.grimmer@teradata.com> wrote in message
news:6f44ad658764d4f5fed224217ad480fb$1@www.eclipse.org...
> We used to have the multiple selects run as a single SQL statement and the
> result sets are displayed correctly, but multiple DDL statements fail. We
> added code to our SQLService to perform the splitSQL, to allow for groups
> to run multiple SQL statements individually. They run fine but we notice
> that with multiple select statements, the result sets are no longer
> displayed in the Results View. We only get a status update.
>
> Should the split prevent result sets from being displayed? Is this a bug
> or further implementation that we need to do for our database support?
> thank you for your response,
> Francine
>

Report message to a moderator

Previous Topic:	Execute SQL in the run toolbar button?
Next Topic:	[Ecore ODA Driver] - Joint data set?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 29 03:52:46 GMT 2017

.:: Contact :: Home ::.