[Gambas-user] Duplicated invalid record inserting into MySQL

[christian.gambas]

Le mercredi 20 août 2008, Benoit Minisini a écrit :
> But do that:
>
>   res = mDatabase.conn.Exec("INSERT INTO customer VALUES(name) (&1)",
> TextBox1.Text)

You're right, Benoît, one could never be careful enough !

But, just to avoid confusion to João Luís, you surely mean :
    res = mDatabase.conn.Exec("INSERT INTO customer (name) VALUES(&1)", 
TextBox1.Text)

Regards.