This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:31 pm, [email protected] wrote: Is the correct answer! Thanks Thomas. Neil --- In [email protected], 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 > ------ 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/348 [Non-text portions of this message have been removed]
