[SQL]Update command with space in table name

[Ruslan Zasukhin]

on 5/12/03 5:34 PM, 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
> 
> Thank you for your help.

Probably this is a bug

-- 
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
-------------------------------------------------------------