This is a notification from the Help Desk.

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

Your user-defined domain DATETIME in the output parameter list?



--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php


==Ticket History==

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]