|
Re: SQL Editor Syntax Error [message #35429 is a reply to message #35361] |
Fri, 24 August 2007 04:26 |
Eclipse User |
|
|
|
Originally posted by: hui.cao.sybase.ocm
Hi,
Can you try to terminate each SQL statement with a ";" in a new line
instead of just by appending ";" at the end of the statement? ( I suppose
this can be done by a batch replace: ";(\r\n)"->"$1;$1" in SQL editor )
Semicolon is not part of the Derby grammar and won't be accepted by the
server, and by default SQL editor only filters out statement
terminators(";") in a standalone line.
--
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:62045b3fe7d206664d23260b44371062$1@www.eclipse.org...
> Hi,
> we work on Derby Network with DTP 1.5.1 (and previous).
> With ij we create the database from DDL we use.
> But when i want to use SQL Editor (with cinnection info) to Execute the
> DDL we have this error Syntax error: Encountered ";".
> Can someone help me?
>
> PS I have tried enablind and disabling sysntax checking but i had the same
> results
>
> Thanks
> Massimo Montecchi
> BS Company Srl
>
|
|
|
|
Re: SQL Editor Syntax Error [message #36141 is a reply to message #36108] |
Fri, 07 September 2007 04:43 |
Eclipse User |
|
|
|
Originally posted by: hui.cao.sybase.ocm
Hi Massimo,
I think your request does make sense. Can you open a bugzilla to track
this problem for Derby enablement? I'll find a time to look into it. Thanks!
--
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:5149a6a22050ffa751ccacdf468f360f$1@www.eclipse.org...
> Hi Max (Hui),
> the hint you give to me it works!!!
> But I think it's not so useful that SQL Editor check the end statement
> only in a new line.
> Think about using DTP for all the development fase: i mean, that we
> develop the db DDL from the DTP plugin and when you estract the DDL from
> DTP the file.sql you have is with ; at the end of every sql line!!!
> Thanks
>
> Massimo Montecchi
> BS Company Srl
>
|
|
|
|
Re: SQL Editor Syntax Error [message #37230 is a reply to message #36141] |
Sun, 14 October 2007 17:50 |
Eclipse User |
|
|
|
Originally posted by: bmf1972.fastmail.fm
Seems to be the same problem with MySQL.
Adrian.
Hui Cao wrote:
> Hi Massimo,
> I think your request does make sense. Can you open a bugzilla to track
> this problem for Derby enablement? I'll find a time to look into it. Thanks!
>
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03916 seconds