I'll give it a try.

Thanks!

Mauricio

> Mauricio,
>
> > I don't know. But I'm not using an Int64 field. I'm
> > using a regular integer.
>
> 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.
>
> 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?
>
> Just some thoughts.
>
> Geoff Worboys
> Telesis Computing
>
>
> eGroups Sponsor
>
>
>