From recordset to json

  1. 3 months ago

    Hi there I have a desktop application that historicaly accessed a local MySQL database, then we ported that database to a cloud server, giving the same acces (MySQL connection) to not change the app. We know this is a security issue and now they are asking me to change that.

    The client wants the databases on their servers now, they will not open any port at all, we only have http or https and PHP7 to access the database, so we can have scripts to get access, query and return the results in json or whatever format.

    Is there any plugin or code so the json could look or behave like a record set, not to change all the system, we use a lot of SQLSelect, SQLExecute, databaserecords, recordset

    Thanks in advance

  2. Maximilian T

    Jan 10 Pre-Release Testers, Xojo Pro Europe, Germany, Berlin

    Your post is titled "From recordset to json" but then you ask "Is there any plugin or code so the json could look or behave like a record set" which is highly confusing and all this additional info about what your client wants and why just thickens the fog....How do you obtain "the json"? Show us some code!

  3. Tim K

    Jan 10 Pre-Release Testers, Xojo Pro

    Sounds like Aloe could help especially the luna express module

or Sign Up to reply!