Thank you for your help. However, is there a way to specifically pull from the table and not have to write to a variable? The example I provided is very streamlined. I really need to do this on about 30 fields and was trying to avoid creating variables.
Here is the code of what I am trying to do. I want to pull only the Project Number field from the hold file onto my html form. Any help would be greatly appreciated!
SET SQLENGINE=SQLORA
SQL SET SERVER &MYSERV
SQL SELECT
det.AGREEMENT_NUM,
det.PROJECT_NUMBER,
det.DURATION
FROM...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.