Mysql community edition and xojo

  1. last week

    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

    Dec 1 Pre-Release 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

    Dec 2 Pre-Release Testers, Xojo Pro UK

    What version of xojo are you using?

  5. Jean-Yves P

    Dec 2 Pre-Release 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!