— The Forums are now read-only —
— All new activity now takes place here: —
This idea would depend on the completion of this Saved SQL Queries idea:
https://www.augforums.com/forums/augsql/saved-sql-queries
Currently, in the SQL Command field on the AugSQL (QQ900001) screen, you can use SQL like this:
DECLARE @MyParam1 VARCHAR(20) SET @MyParam1='AACUSTOMER' DECLARE @MyParam2 VARCHAR(20) SET @MyParam2='ABARTENDE' SELECT AcctCD, AcctName FROM BAccount WHERE CompanyID=2 AND AcctCD IN (@MyParam1,@MyParam2)
Which returns results like this:
What if you put the SQL Code above in the SQL Command field on the AugSQL Saved Queries (QQ900003) screen and save it.
Then, what if you could populate the @MyParam1 and @MyParam2 values at runtime in the URL. There would also need to be a parameter that tells the query to run. Maybe something like this:
That would be interesting. Actually, that would change my approach to the Schedule Queries Idea (click here) so I'm going to add to that Discussion with another idea.
By using this website, you agree to our Terms of Use (click here)

