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

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
zorino
Posts: 3
Joined: Fri 29 Oct 2021 14:45

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

Post by zorino » Fri 29 Oct 2021 14:52

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 !

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

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

Post by MaximG » Wed 03 Nov 2021 10:42

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!

zorino
Posts: 3
Joined: Fri 29 Oct 2021 14:45

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

Post by zorino » Thu 04 Nov 2021 11:05

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

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

Post by MaximG » Tue 09 Nov 2021 12:31

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.

Post Reply