> I had created a Test.fdb with the following table using ISQL:
>
> SQL> create table Staff (id int not null, name char(64), job
> varchar(64), dept smallint, managerId integer, years smallint, salary
> double precision, primary key (id));
>
> SQL> insert into Staff values(10, 'Amy Ambrose', 'Supervisor', 101,
> 110, 5, 50000.56);
> SQL> insert into Staff values(110, 'Barbara Betty', 'Manager', 101, 0,
> 15, 150000.57);
> SQL> commit;
>
> I can query it using ISQL and displayed with values expected.
>
> But when I shutdown Firebird server, start my embedded applicaiton,
> with the following select stmt:
>
> select id, dept from Staff;
>
> what I got is this:
>
> id: 10 dept: -859045787
> id: 110 dept: -859045787
>
> My SQLDA declarion is:
>
> pSqlda->sqlvar[1].sqldata = (char *)&dept;
> pSqlda->sqlvar[1].sqltype = SQL_SHORT + 1;
> pSqlda->sqlvar[1].sqlind = &deptFlag;
>
> I experiment with different datatype such as SQL_LONG did not get me
> anywhere. The only thing that works is if I go back to use INTEGER
> for column dept, then it works fine.

SMALLINT is 2 byte value, it seems your application reads 8 bytes ...

Ivan