[Gambas-user] MySQL

[Steven Lobbezoo]

Hi,

I got into a problem with MySQL
If i do
      update Ventes Set ..... bla bla bla,  Code = (SELECT MAX(Code) FROM 
Ventes) + 1 
which is perfectly valid under MySQL, i get an (Gambas ?) error message
stating that I cannot update Ventes width the above subquiry ????

I suppose I'm doing something wrong, but since the error message is not from 
Mysql (You have an error in your Mysql syntax bla bla bla...), i thought I 
ask first here.

Thanks,
Steven