Programming with dBASE

Author

Array max

Rick

2005-04-16, 8:23 pm

I can't seem to find in the OLH the maximum size permitted for an array in 2.21. Anyone know what that is, and if it changes for single vs. multiple dimensions?

Also, anyone know where I can find review of other maximums, e.g., max fields, max size of a field, etc. just for future reference.

Thanks,
Rick

Ken Mayer [dBVIPS]

2005-04-17, 9:23 am

Rick wrote:
> I can't seem to find in the OLH the maximum size permitted for an
> array in 2.21. Anyone know what that is, and if it changes for
> single vs. multiple dimensions?

Hmm. I don't know that this is in the OLH or anywhere. It may depend on
available memory ...

> Also, anyone know where I can find review of other maximums, e.g.,
> max fields, max size of a field, etc. just for future reference.

Not much help, but it's in the appendices for my book (which isn't
published yet, but getting closer). You might check the archives -- I
know this has been posted in messages in the newsgroups.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Ivar B. Jessen

2005-04-17, 11:23 am

On Sat, 16 Apr 2005 16:02:00 -0400, Rick <Sportman7@netzero.net>
wrote:

>I can't seem to find in the OLH the maximum size permitted for an array in 2.21. Anyone know what that is, and if it changes for single vs. multiple dimensions?

See OLH on DECLARE:

"The array can hold as many elements as memory allows. You can create
arrays that contain more than two dimensions, but most dBL array
functions work only on one- or two-dimensional arrays".

>Also, anyone know where I can find review of other maximums, e.g., max fields, max size of a field, etc. just for future reference.

See OLH on Field types:

"Each field has a defined field type, which determines the kind of
information it can store. For example, a character field accepts all
printable characters including spaces. You can define up to 1,024
fields in a table.

A dBASE (.DBF) table can contain the following field types.

Field type Default size Maximum size Index allowed? Allowable
values
Character 10 characters 254 characters Yes All keyboard
characters
Numeric 10 digits,
0 decimal 20 digits Yes Positive or negative numbers
Float 10 digits,
0 decimal 20 digits Yes Positive or negative numbers. Identical
to Numeric; maintained for compatibility".

Ivar B. Jessen

Marty Kay

2005-04-18, 3:23 am

> I can't seem to find in the OLH the maximum size permitted for an array in
2.21.
> Anyone know what that is, and if it changes for single vs. multiple
dimensions?

Internally, dBASE Plus arrays use an unsigned 32 bit integer to track the
total number of elements in an array.
Therefore, the theoretical limit on the total number of elements in an array
is (2^32)-1
or 4,294,967,295 elements.

> Also, anyone know where I can find review of other maximums, e.g., max
fields, max size of a field, etc. just for future >reference.

The dBASE Plus 2.5 Online Help file and the downloadable Language Reference
includes a section on BDE Limits
which should answer many of your questions.

- Marty Kay (dBI) -

Rick

2005-04-18, 1:23 pm

Thanks Marty,

Rick

Marty Kay Wrote:

> 2.21.
> dimensions?
>
> Internally, dBASE Plus arrays use an unsigned 32 bit integer to track the
> total number of elements in an array.
> Therefore, the theoretical limit on the total number of elements in an array
> is (2^32)-1
> or 4,294,967,295 elements.
>
>
> fields, max size of a field, etc. just for future >reference.
>
> The dBASE Plus 2.5 Online Help file and the downloadable Language Reference
> includes a section on BDE Limits
> which should answer many of your questions.
>
> - Marty Kay (dBI) -
>
>
>

Rick

2005-04-18, 1:23 pm

Thanks Ivar,

Rick

Ivar B. Jessen Wrote:

> On Sat, 16 Apr 2005 16:02:00 -0400, Rick <Sportman7@netzero.net>
> wrote:
>
>
> See OLH on DECLARE:
>
> "The array can hold as many elements as memory allows. You can create
> arrays that contain more than two dimensions, but most dBL array
> functions work only on one- or two-dimensional arrays".
>
>
> See OLH on Field types:
>
> "Each field has a defined field type, which determines the kind of
> information it can store. For example, a character field accepts all
> printable characters including spaces. You can define up to 1,024
> fields in a table.
>
> A dBASE (.DBF) table can contain the following field types.
>
> Field type Default size Maximum size Index allowed? Allowable
> values
> Character 10 characters 254 characters Yes All keyboard
> characters
> Numeric 10 digits,
> 0 decimal 20 digits Yes Positive or negative numbers
> Float 10 digits,
> 0 decimal 20 digits Yes Positive or negative numbers. Identical
> to Numeric; maintained for compatibility".
>
>
> Ivar B. Jessen

Rick

2005-04-18, 1:23 pm

Thanks Ken,

I couldn't seem to find it, but Ivar pointed it out, and it sounds like (from Marty) the newest olh has more info.

Rick

Ken Mayer [dBVIPS] Wrote:

> Rick wrote:
>
> Hmm. I don't know that this is in the OLH or anywhere. It may depend on
> available memory ...
>
>
> Not much help, but it's in the appendices for my book (which isn't
> published yet, but getting closer). You might check the archives -- I
> know this has been posted in messages in the newsgroups.
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase

Sponsored Links