FIXED: [SQL]Update command with space in table name

[Ruslan Zasukhin]

on 6/30/03 17:17, Francois Van Lerberghe at fvanlerberghe at freegates.be
wrote:

I have found problem, Francois.
Thank you for report.

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

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