I tried to add,edit my program but still mysql didn’t updated though… could pls help …
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.
You might also want to review the example included with Xojo to see how to set up your Xojo code:
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.