[SQL]Update command with space in table name

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Jun 28 09:24:04 CDT 2003


on 5/12/03 17:34, Francois Van Lerberghe at fvanlerberghe at freegates.be
wrote:

> Hello,
> 
> I'm just testing the update command and it doesn't seem to work when the
> table name or the field name has space in it. Is there some special syntax
> or is it a bug ?
> 
> UPDATE myTable SET myField='test' WHERE myField='wrong'          => OK
> UPDATE [my Table] SET [my Field]='test' WHERE [my Field]='wrong' => not OK

Hi Francois,

What version do you use?

I have look into sources, and this should work.
At least in latest 1.9.8 betas.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list