[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
> 
> Hi Francois,
> 
> What version do you use?
> 
> I have look into sources, and this should work.
> At least in latest 1.9.8 betas.

Mmmh, I don't remember for sure. Certainly not the latest 1.9.8b7 that have
the creation date of 5/27/03. But at the time of the reported bug, this was
the latest avaiable.
I'll go the test again with the latest and let you know.


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