Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug in Update SQL
Message
From
28/11/2002 02:13:09
 
 
To
28/11/2002 01:21:34
Peter Easson
Catalina Trading
Sydney, Australia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00727872
Message ID:
00727880
Views:
11
>Whilst setting up a Table to save the form control positions, I used the following code
>UPDATE ControlProps SET Left = oControl.Left,;
> Top = oControl.Top,;
> Height = oControl.Height,;
> Width = oControl.Width WHERE Name=oControl.Name
>
>which generated an error on compiling. By changing the Table field name to nLeft and the update expression to nLeft = oControl.Left, it compiled perfectly.
>
>It appears that the word 'Left' is causing the error when other language 'names' are OK.
>

Since LEFT JOIN is legal SQL syntax, LEFT is a reserved word. That's probably why the compiler is complaining.

As you probably already know it's never a good idea to use reserved words for identifiers, but especially reserved words that are part of the syntax of the command in question.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform