>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