> -----Original Message-----
> From: Geoff Worboys [mailto:geoff@...]
> Sent: Miércoles 3 de Enero de 2001 15:11
> To: IBObjects@egroups.com
>
> Can you please try an explicit cast to integer in your SQL. eg:
>
> SELECT CAST( ID AS INTEGER ) ...
>
> Because at the moment I cannot see out a "type 14" would get into a
> variant from an integer field. I am just wondering whether IB6
> dialect 3 may be doing something a little strange.

IB6 on dialect 3 will promote a field to INT64 on any numeric operation, so
select 1+2 from rdb$database
produces 3 in a 64-bit integer.

> Another thought also crossed my mind. Are you using a SchemaCache,
> and if so have you made sure you have cleared the cache since last
> changing the table?

I recall I wrote that before in this thread and I don't know if this is the
case.

C.