Question

Update application data without SQL statements

0

Hello I working on an Application in a production environment, there are objects with wrong data that need to be modified through SQL statements that are sent to the client in a file. The client refuses this method and wants to modify this data from the Application itself without a direct connection to the database. Is there a way in Mendix other than the database connector?

asked 2022-10-16

Abdullah Alqadri

2 answers

Ronald Catersels · Answer 1 · 2022-10-16

Ok I might misunderstand you, but is my assumption right that you have data in your Mendix application that is wrong and needs to be set right? Because then I just would write a hotfix microflow that retrieves those objects and do the corrections in that microflow. I would indeed not fix this through SQL statements directly on the database.

Regards,

Ronald

Tim v Steenbergen · Answer 2 · 2022-10-17

Since your client refuses the SQL-method and defines the requirement to change the data from ‘the application itself’ also will prevent the client from accepting any other way of writing to the database. So, create a page showing the errorneous data and on that page aloow the customer to correct the data and save it.

Also, prevent the data from being faulty. Correct the process that causes this problem.