Hello Mayssa,
Please allow me to address your questions below:
I'm afraid not. Please note that this might not be achievable, since you are using a setup that may have not been created with Advanced Installer anyway.
2. Is it possible to print/log text when executing an SQL script for debugging reasons?
Not quite sure this is possible. However, you could enable logging for your scripts through the
"Log errors to file" option (this has been renamed, from what I can see, to
"Log information to file" - we will update the user guide accordingly)
3. I want to call a function in SQL and then assign its return value to an Advanced Installer property.
In my screenshot below you can see that I tried to assign the value of "@NewSiteID" to the property "$SiteIDProp$" which I replaced using the Replacements Tab with "[SELECTED_SITE_PROP]". Is this possible somehow?
I am not an expert in SQL, but is it even possible to give value to a function? For instance, can you do this outside of Advanced Installer?
4. I also tried to achieve 3. using an Advanced Installer SQL Query but as soon as I am adding the "EXEC @NewSiteID = ..." line it is failing to assign the ID. Is the exec statement somehow not executed poperly here?
Here, most likely, it is not possible to achieve your needs through an SQL Query. The query, as the name suggests, should only be used to query a database (e.g. using SELECT statement).
Best regards,
Catalin