Skip to main content


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 21:21 Go to next message
Eclipse UserFriend
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] Mon, 16 June 2008 02:48 Go to previous message
Eclipse UserFriend
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] Mon, 16 June 2008 02:48 Go to previous message
Hui Cao is currently offline Hui CaoFriend
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: Thu Mar 28 10:38:09 GMT 2024

Powered by FUDForum. Page generated in 0.02135 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top