--- In IBObjects@y..., "alexp772001" <alexp772001@y...> wrote:

> Hi,
> I have the following table:
>
> CREATE TABLE WORKS (
> WORK_ID INTEGER NOT NULL,
> PROJECT_CATEGORY SMALLINT,
> DISPLAY_ORDER SMALLINT,
> WORK_YEAR CHAR(4) NOT NULL,
> IMAGE VARCHAR(20) NOT NULL,
> CUSTOMER_NAME VARCHAR(30) NOT NULL,
> PROJECT_TYPE VARCHAR(100) NOT NULL,
> DESCRIPTION_ITA BLOB SUB_TYPE 1 SEGMENT SIZE 80,
> DESCRIPTION_ENG BLOB SUB_TYPE 1 SEGMENT SIZE 80);
>
> and a TIB_Cursor with the following SQL:
>
> SELECT FIRST 1 SKIP ?SKIP_ROWS
> WORKS.WORK_YEAR,
> WORKS.IMAGE,
> WORKS.CUSTOMER_NAME,
> WORKS.PROJECT_TYPE,
> WORKS.DESCRIPTION_ITA
> FROM
> WORKS
> WHERE
> WORKS.PROJECT_CATEGORY = ?PROJECT_CATEGORY
> ORDER BY WORKS.DISPLAY_ORDER
>
> If I set SKIP_ROWS to 0 and PROJECT_CATEGORY to 1 the dataset will

be

> empty, but if I set SKIP_ROWS to 1 and PROJECT_CATEGORY to 1 one

row

> is returned correctly.
> If I remove the WHERE condition it works fine.
> I noticed that PROJECT_CATEGORY parameter is recognized as an INT64
> and that if I remove the SKIP_ROWS parameter and set the value in

the

> sql statement everything works fine.
>
> Am I missing something or is it a bug?
>
> Thank you in advance.
>
> Regards,
> Alessandro Petrelli.

Noone here that can check this?

Regards,
Alessandro Petrelli.