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?
myDB.sqlexecute("COMMIT;")or myDB.commit if xojo>=2019r2
some ideas coming :
check for error codes after each sqlexecute/sqlselectwhat 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?
Edward j likes this.
Using newest version thanks for the help guys