Im adding a window in our PB app that will allow the user to select
from a list of saved .SQL files and execute one file then show the results in a report (datawindow).
I have the framework done I'm just deciding on the best way to create the datawindow used for the report.
The main question I have is:
1. How to dynamically create the datawindow with the column headers based on the sql statement where I dont know what the column headers will be before hand. Such as that If I have a statement like 'select * from employee' I can get a datawindow generated that will look like this:
Emp Name Emp # Emp Address
--------------------------
----
John 1 123 Main
...
Start Free Trial