Hi all, I'm very new to Progress OpenEdge... so I hope I'm in the right spot.
I work for a school district that uses Skyward as a student information system. Skyward uses Progress OpenEdge database. I'm trying to create a query with input parameters for a Crystal Report. I just want to copy/paste my query into Crystal. I have no problems connecting Crystal Reports to the Progress DB via ODBC.
My problem is that I cannot figure out how to use parameters in a query in Progress. I just want to do something really basic like this (in T-SQL):
How do I write a similar query in Progress?
I work for a school district that uses Skyward as a student information system. Skyward uses Progress OpenEdge database. I'm trying to create a query with input parameters for a Crystal Report. I just want to copy/paste my query into Crystal. I have no problems connecting Crystal Reports to the Progress DB via ODBC.
My problem is that I cannot figure out how to use parameters in a query in Progress. I just want to do something really basic like this (in T-SQL):
Code:
DECLARE @School_ID int;
SELECT FirstName, LastName
FROM Students
WHERE School_ID = @School_ID;
How do I write a similar query in Progress?