Subject | Re: [IBO] Re: Fields[xx].value - unidentifyed type: 14 |
---|---|
Author | Geoff Worboys |
Post date | 2001-01-03T19:11:17Z |
Mauricio,
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
> I don't know. But I'm not using an Int64 field. I'mCan you please try an explicit cast to integer in your SQL. eg:
> using a regular integer.
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