Devart Forums

I have a TOraQuery with this SQL:

select name, name as client_name from client

In TOraQuery defined two fields NAME and CLIENT_NAME as TStringField
and Size = 100 both.

Then I change SQL in runtime to:

select name, to_char(null) as client_name from client

and get error with message:

"Size mismatch for field 'CLIENT_NAME', expecting: 100, actual: 1"

ORACLE 8.0.6, 9.2.0.5, Delphi 7

But this was work on ODAC 4.10.0.10
What's wrong?

This problem occurs on Delphi 7 with update pack 1 only. You can upgrade your Delphi with update pack 1.1 or remove update 1 from your IDE.