mysql add, edit, update sample

Mohamad_Hanif_Md_Saa · January 26, 2015, 5:04am

I tried to add,edit my program but still mysql didn’t updated though… could pls help …

David_Cox · January 26, 2015, 10:32am

Maybe you need to GRANT your user those rights. Also, ensure your database is allowed to be accessed other than from itself. I would search Google to understand these MySQL features and download the MySQL Workbench to carry them out.

Paul_Lefebvre · January 26, 2015, 2:18pm

You might also want to review the example included with Xojo to see how to set up your Xojo code:

Examples/Database/MySQL/MySQLExample

Bob_Keeney · January 26, 2015, 2:41pm

And always, always, always check the Database.Error bit after doing any SQL action (SQLExecute, SQLSelect). You might have an error and don’t even know it.