Page 1 of 1

Delphi TField.Size with VARCHAR2(1000) type returns zero

Posted: Fri 29 Oct 2021 14:52
by zorino
Hi,

I'm using ODAC components with Delphi 5.

I tried MyQuery.FieldByName('XXX').Size with :
- XXX = VARCHAR2(32) -> returns 32, that's OK
- XXX = VARCHAR2(1000) -> returns 0, that's wrong !
- XXX = VARCHAR2(4000) -> returns 0, that's wrong !

Is it a known problem and is there a way to avoid it ? (I mean how else can i get the size of a varchar2(4000) field ?)

Thx for any help !

Re: Delphi TField.Size with VARCHAR2(1000) type returns zero

Posted: Wed 03 Nov 2021 10:42
by MaximG
Hi there!
Thanks for your question and interest in our product! Please note that we have not supported Delphi 5 for a long time.
Could you please specify the ODAC version you are using? Please, let us know if you have any questions!

Re: Delphi TField.Size with VARCHAR2(1000) type returns zero

Posted: Thu 04 Nov 2021 11:05
by zorino
Hi,

It is a Professional Edition 9.4.14 for Delphi 5
Of course i don't imagine this bug will be fixed, just tell me please if there is another way to know the size of such fields with this ODAC version ?

Thx

Re: Delphi TField.Size with VARCHAR2(1000) type returns zero

Posted: Tue 09 Nov 2021 12:31
by MaximG
Kindly be informed that we haven't supported Delphi 5 for a long time. Therefore, the only way to get the correct value is to update ODAC to the latest version. The minimum version of the IDE supported by our components is Delphi 6 and we always suggest to our users to consider the ability to upgrade to this or an older version, because we will maintain compatibility with it for quite a long time.