Is the correct answer!

Thanks Thomas.

Neil

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <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
>