This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:31 pm, lists@... wrote:
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;

------
This is an automated response. Your issue has been noted. We'll be in touch soon.



Please reply to this email or visit the URL below with any additional details.

http://DANTOIN:9675/portal/view-help-request/347




[Non-text portions of this message have been removed]