Mysql community edition and xojo

I’m trying to connect xojo to my database the SQL commands I’ve generated in text boxes work in the Mysql workbench, but don’t link from xojo to Mysql table, I’ve tried alot of diffent code examples but none work I’m wondering if anyone can help me?

some ideas coming :

check for error codes after each sqlexecute/sqlselect
what do they say ?
is the database connected ?
did you try to commit your requests ?

How do I commit the request im connected with no errors I had the error catching code and because the database shows in both xojo and workbench could you give me the commit codes please?

What version of xojo are you using?

myDB.sqlexecute(“COMMIT;”)
or myDB.commit if xojo>=2019r2

Using newest version thanks for the help guys