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.