Mysql community edition and xojo

  1. 7 months ago

    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

  2. Jean-Yves P

    1 Dec 2019 Testers, Xojo Pro Europe (France, Besançon)

    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 ?

  3. 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?

  4. Julian S

    2 Dec 2019 Xojo Pro UK

    What version of xojo are you using?

  5. Jean-Yves P

    2 Dec 2019 Testers, Xojo Pro Answer Europe (France, Besançon)

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

  6. Using newest version thanks for the help guys

or Sign Up to reply!