Size Mismatch problem

[fabiano]

I'm recompiling an old project. Now on some OracleDataSets I've the following error opening the DataSet:
"DSetxxx: Size mismatch for field 'field1', expecting: 40 actual:31."
I've seen that in Delphi I've defined 40 as the size of field1, and in Oracle it is 31, BUT this isn't changed! (old project worked fine with this mismatch!) and more: I've this problem also with fields that are calculated fields in the query (concatenation of Varchar2 fields or fields resulting from a union query between varchar2 fields and constants...in this case I don't know the exact resulting field size!

I'm using Delphi 7 with DOA 3.4

I've upgraded recentrly delphi to 7.1 version, may be a cause?

Fabiano

 

[Uli Kobsa]

There is a problem (or better a fix) in D7.1
Read http://community.borland.com/article/0,1410,32353,00.html for example.

best regards,
Uli

 

[fabiano]

Thanks, very useful reference! (but not so good delphi bug fix!).

Fabiano

 

[Uli Kobsa]

Have also a look for http://community.borland.com/article/0,1410,32365,00.html.
Borland released a public beta for this issue. Maybe this can help you.

greetings,
Uli

 

[fabiano]

Ok, thanks.
This fix is very useful to maintain backward compatibility.
In design time the size mismatch remains, but at runtime all appears to work as in 7.0 version.