Hi, I wanted to ask about the possibility of testing SQL(4GL) queries in Cloud Infor LN. I would like to prepare query for a script or report, check it in editor such a SQL - what data they return, what they look like, what type fields are, whether the tables are joined correctly and quickly correct it.
How can you develop/test a query in a cloud environment?
I would like to be able to use this prepared query in a script, assign values ??to variables and use it in the 4GL script.