Re: MySQL 5 and 'delimiter'

2005-08-08 Thread Gleb Paharenko
Hello. For a pity I'm not familiar with Deplhi. > > Thanks. So it seems that it's only a command line statement. > > Any idea why I get the error when executing the full CREATE > from a Delphi VCL component? Weird thing is, the procedure > is saved to the database. > > With r

Re: MySQL 5 and 'delimiter'

2005-08-08 Thread Martijn Tonies
> > Comments from: > > http://bugs.mysql.com/bug.php?id=12344 > > > > might be helpful. > > Thanks. So it seems that it's only a command line statement. > > Any idea why I get the error when executing the full CREATE > from a Delphi VCL component? Weird thing is, the procedure > is saved to the d

Re: MySQL 5 and 'delimiter'

2005-08-08 Thread Martijn Tonies
Hello Gleb, > Hello. > > > Comments from: > http://bugs.mysql.com/bug.php?id=12344 > > might be helpful. Thanks. So it seems that it's only a command line statement. Any idea why I get the error when executing the full CREATE from a Delphi VCL component? Weird thing is, the procedure is saved

Re: MySQL 5 and 'delimiter'

2005-08-08 Thread Gleb Paharenko
Hello. Comments from: http://bugs.mysql.com/bug.php?id=12344 might be helpful. "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi there, > > I'm a bit puzzled about the DELIMITER statement. > > Is this a command-line SQL statement only, or is this actually processed > on t

MySQL 5 and 'delimiter'

2005-08-08 Thread Martijn Tonies
Hi there, I'm a bit puzzled about the DELIMITER statement. Is this a command-line SQL statement only, or is this actually processed on the server? And if it's a command-line thingy only, shouldn't I be able to execute something like: CREATE PROCEDURE P_AA() MODIFIES SQL DATA begin delete from