[SQL]Update command with space in table name

[Francois Van Lerberghe]

le 28-06-03 8:24, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :

> 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

Here are the results of my tests.
RB 3.5.1
V4RB 1.9.8b7
MacOS Classic 9.1 French

1/
UPDATE [Détail transactions] SET [Code TVA] = '1' WHERE [Code TVA] = '0'
=> Error 602 : Field not found

2/
UPDATE [Table] SET [Ref fld] = '1' WHERE [Ref fld] = '0'
=> Error 603 : Syntax error

3/
UPDATE [Users] SET [Ref] = '01' WHERE [Ref] = '00'
=> No error

All fields are String.

Thank you.

François Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique