[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