I'm trying to test my database application which uses a mysql
community server.
I'm trying to force the database creation to fail by passing in an
illegal string of characters for the database name.
However the sql statement doesn't generate an error... but it also
doesn't create the database...
I'm developing in REALBasic. The string I'm passing for the database
name is "`~`~`~`".
(For lack of a more ridiculous name.)

I would have thought the create schema statement would have failed..
Maybe this is an issue in RB?

On 21-01-11 17:54, SpreadTooThin wrote:
try:

mysql> create database `abc def `;
ERROR 1102 (42000): Incorrect database name 'abc def '


--
Luuk

On Jan 21, 12:36*pm, Luuk <L... (AT) invalid (DOT) lan> wrote:
no it worked and I have a database called 'abc def'

On 21-01-11 21:59, SpreadTooThin wrote:
you forgot to add the last space, after the 'f'...

--
Luuk

On Jan 21, 2:41*pm, Luuk <L... (AT) invalid (DOT) lan> wrote:
Indeed... and as you said that is an illegal database name, however I
get no error in RB.
I think I need to move this thread to the REALBasic forum.
Thanks.

El 21/01/2011 17:54, SpreadTooThin escribió/wrote:
I know nothing about REALBasic but I've seen many amateur code snippets
in other langs like PHP that send a query to the server, never check the
return code and even instruct the language to hide all error messages.
Could that be the case? Being a client-server application, MySQL has no
direct way to yell the user.


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

On Jan 24, 1:43*am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:
It's hard to tell what is going on past the script I'm writing..
I've taken the string that is passed on to the database and broken it
out into discrete lines of sql...
That works... but I'm left wondering why neither of the schemas were
created and no error was generated.