DefinedSize property of Field object

[Lorenzo Bolognini]

Hi all,

why is the DefinedSize of the Field object of type adInteger returning the
value 4 and the same property on a adVarWChar type field (Text in MS Access)
is returning the max length of the string that it may contain (for example
52)?

I'm using ADO 2.8

Thank You,
Lorenzo

[Bob Barrows]

Lorenzo Bolognini wrote:

Hi all,

why is the DefinedSize of the Field object of type adInteger
returning the value 4 and the same property on a adVarWChar type
field (Text in MS Access) is returning the max length of the string
that it may contain (for example 52)?

I'm using ADO 2.8

Thank You,
Lorenzo

Because it takes four bytes (32 bits) to hold the largest available integer
value (2,147,xxx,xxx - I haven't memorized this one - you can look it up if
you're so inclined).

Don't forget, unicode (adVarWChar) takes twice the characters to store the
same data as non-unicode types (adVarChar).

[Lorenzo Bolognini]

"Bob Barrows" <re******@NOyahoo.SPAMcom> ha scritto nel messaggio
news:%2****************@TK2MSFTNGP11.phx.gbl...

Lorenzo Bolognini wrote:

Hi all,

why is the DefinedSize of the Field object of type adInteger
returning the value 4 and the same property on a adVarWChar type
field (Text in MS Access) is returning the max length of the string
that it may contain (for example 52)?

Because it takes four bytes (32 bits) to hold the largest available

integer value (2,147,xxx,xxx - I haven't memorized this one - you can look it up if you're so inclined).

I did imagine something like that but why is the return type of the
DefinedSize of a different type for the two types of field (text and
integer)? Does that make sense?

Thank You for your help,
Lorenzo

[Bob Barrows]

Lorenzo Bolognini wrote:

"Bob Barrows" <re******@NOyahoo.SPAMcom> ha scritto nel messaggio
news:%2****************@TK2MSFTNGP11.phx.gbl...

Lorenzo Bolognini wrote:

Hi all,

why is the DefinedSize of the Field object of type adInteger
returning the value 4 and the same property on a adVarWChar type
field (Text in MS Access) is returning the max length of the string
that it may contain (for example 52)?

Because it takes four bytes (32 bits) to hold the largest available
integer value (2,147,xxx,xxx - I haven't memorized this one - you
can look it up if you're so inclined).

I did imagine something like that but why is the return type of the
DefinedSize of a different type for the two types of field (text and
integer)? Does that make sense?

Thank You for your help,
Lorenzo

Why wouldn't it be? I don't understand the question. The defined size of an
integer field has to be 4. The defined size of a Text field is whatever the
size is defined to be in the database.

Bob Barrows