I first started using the SQL Builder when I was creating a Grid that incorporated data from two tables. The aliases are; Header and Catalog. I used the SQL Builder and tested the results. Once I did that and got the desired result I just copied the SQL to the “Lookup Settings” for the field in question. WOW! was that ever COOL!!!
-
Could the Scriptcase developers provide a link in the “Lookup Settings” for the “Field(s)” properties of the applications that will allow for Saved or highlighted SQL code to be copied in? This would be such a time saving feature. I can copy the SQL, true, but having the link to do it for me would be so…sweet.
-
Could the SQL Builder have a new feature that will create a Stored Procedure from the built/saved query?
I have been using Scriptcase for about a month now, but boy oh boy does it have true app building power.