SQL Editor multiple select statements [message #40430] |
Mon, 07 January 2008 21:21 |
Eclipse User |
|
|
|
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 |
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
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.03494 seconds