Type mismatch expected integer actual float (again)

[Maxim Korobov]

I'll use following settings in Session:
FloatPrecision = 0,
IntegerPrecision = -1
SmallintPrecision = -1

So all NUMBER fields in DB are interpreter as Float.
That's ok for all fields except one with "NUMBER(1) nullable default 0". On this field raised Delphi Exception "Type mismatch expected integer actual float (again)".

It's important there are no errors on other PC.

Any ideas?

 

[Marco Kalter]

We'll check it out. As a workaround you can query the column with a dummy expression (e.g. column * 1 or column + 0).

 

[Maxim Korobov]

Can you explain how it work?

And, maybe, any more ideas? It's important because other department don't want to fix it in the DB Engine project.

 

[Marco Kalter]

Can you explain how it work?

The workaround you mean? Instead of this statement:

select * from dept

You could write:

select deptno + 0 as deptno, dname, loc from dept

The deptno + 0 expression will be represented as a float by Oracle.

 

[Maxim Korobov]

We have 2 types of forms in project:
ordinary forms and runtime-generatend (from .dfm-files which are stored in DB).
When i (on ordinary form) remove field description from a Fields Editor in Delphi and add it back it works! No errors with this form. But there is a big trouble to do like that with dfm-generated forms.

So maybe there is something with Oracle Client properties on only my PC.

 

[Maxim Korobov]

As you understood the problem is not limited to a specific table/column.