[Gambas-user] MySQL

[Benoit Minisini]

On jeudi 30 août 2007, Steven Lobbezoo wrote:
> 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
>

Please:
- Tell which version of gambas you use.
- Tell what is actually the query (how can I guess what 'bla bla bla' is?)
- Better, send a full Gambas project.

Thanks in advance.

Regards,

-- 
Benoit Minisini