RE: [Firebird-net-provider] select quick

[Marco B. <mar...@ai...>]

(Sorry for this off-topic question...)

Hi Alessandro... like Paola, I have a stored proc that needs to be improved
that way.

But I receive an error if I try to use FIRST... SKIP in a stored procedure.

Thanks in advance.

Here is the code:
--
alter PROCEDURE "sdqFORUMMSGSet_msgs"
    
(        
"_GHOST" SMALLINT,
"_ISDELETED" SMALLINT,
"_ID_SENDER" INTEGER,
"_ID_FORUM" INTEGER,
numrows INTEGER,
numfrom INTEGER
)

RETURNS
(
"GHOST" SMALLINT,
"ISDELETED" SMALLINT,
"ID" INTEGER,
"ID_SENDER" INTEGER,
"ID_FORUM" INTEGER,
"CREATED" TIMESTAMP,
"NICK_SENDER" VARCHAR(20),
"BODY" VARCHAR(2000)        
)

AS

BEGIN


    FOR
    SELECT FIRST :numrows SKIP 5
        
        "GHOST",
        "ISDELETED",
        "ID",
        "ID_SENDER",
        "ID_FORUM",
        "CREATED",
        "NICK_SENDER",
        "BODY"

    FROM
        "FORUMMSG"

    WHERE
        
        ("GHOST" = :"_GHOST" OR :"_GHOST" IS NULL)
         AND ("ISDELETED" = :"_ISDELETED" OR :"_ISDELETED" IS NULL)
         AND ("ID_SENDER" = :"_ID_SENDER" OR :"_ID_SENDER" IS NULL)
         AND ("ID_FORUM" = :"_ID_FORUM" OR :"_ID_FORUM" IS NULL)

ORDER BY CREATED desc

    INTO
        
        :"GHOST",
        :"ISDELETED",
        :"ID",
        :"ID_SENDER",
        :"ID_FORUM",
        :"CREATED",
        :"NICK_SENDER",
        :"BODY"
                  
    
  DO
  BEGIN
    SUSPEND;
  END


END
--


> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of Alessandro Petrelli
> Sent: Wednesday, February 18, 2004 12:59 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] select quick