Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Editor multiple select statements
SQL Editor multiple select statements [message #40430] Mon, 07 January 2008 16:21 Go to next message
Francine Mising name is currently offline Francine Mising name
Messages: 14
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
Re: SQL Editor multiple select statements [message #45540 is a reply to message #40430] Sun, 15 June 2008 22:48 Go to previous message
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
>
Re: SQL Editor multiple select statements [message #591496 is a reply to message #40430] Sun, 15 June 2008 22:48 Go to previous message
Hui Cao is currently offline 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
>
Previous Topic:Execute SQL in the run toolbar button?
Next Topic:[Ecore ODA Driver] - Joint data set?
Goto Forum:
  


Current Time: Mon Jul 28 08:28:13 EDT 2014

Powered by FUDForum. Page generated in 0.03446 seconds