Mysql, executesSQL ( INSERT INTO )

General
1

Hello

It is my code:

SQL = "INSERT INTO " + “parametres”

SQL = SQL+ " (nom) VALUES (‘Seagulls’);"

Try

Me.ref_Connexion.ExecuteSQL ( sql )

Catch er

tx = "Erreur: " + er.Message

End Try

I have an erreur (Number 0 ) with Xojo

but with SEQUEL pro, it is ok

Where is my probleme ?

Thank you

2

Often, people find that the database they connect to, is not the one they think they are using.
Try a select statement beforehand: is there data in there already?

Is the database in your resources folder, and read-only?

3

Thank you
It is a stupid mistake !!!

→ Me.ref_Connexion is Nil !!!

I’m ashamed