Hi
I am trying to create the following SP but am receiving the message "Feature
not supported on ODS version older than 11.1" but I cannot work out what it is
that it doesn't like about the SP.
For information this is a Firebird 2.1 database but it is an ODS v10
SET AUTODDL OFF;
SET TERM ^ ;
CREATE PROCEDURE SP_LATEST_VACANCY_STATUS (
VACID INTEGER )
RETURNS
(
STAUSNAME VARCHAR(500),
LASTUPDATE DATETIME
)
AS
BEGIN
FOR
SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE
FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH
WHERE VCO.VACID = :VACID
AND VCO.STATUS = VST.STATUSID
AND VCH.VACID = VCO.VACID
AND VCO.CONTID = VCH.CONTID
AND VCO.STATUS = VCH.STATUS
ORDER BY VCO.STATUS DESC
INTO :STATUSNAME, :LASTUPDATE
DO
SUSPEND;
END
^
SET TERM ; ^
COMMIT WORK;
