Page 1 of 1

Feature for a Dbf archive - Request info to Experts

PostPosted: Mon Oct 25, 2021 11:21 am
by Silvio.Falconi
I found these features for a dbf archive

1) the field name can only contain ten characters (spaces are converted to underscores, letters are converted to uppercase)
2) duplicate field names are not allowed
3) a maximum of 128 fields are allowed
4) a maximum of 254 characters are allowed per field
5) a maximum of 4000 bytes per record are allowed

for point 2 i tried with emg application and i found that i can have two fields of the same name how is this possible? ( see the picture down)

Image

for point 3 I found that I can manage more than 128 fields in fact I tried to create an archive of 511 fields (see the picture down) and it works at least with the EMG application, how is this possible? that is actually how many fields can one do max?

Image

Re: Feature for a Dbf archive - Request info to Experts

PostPosted: Wed Oct 27, 2021 7:51 pm
by Marc Venken
Point 2 :

You can have only 1x the same fieldname

What you show is 2x a record name

Point3 : I think 1024 fields

https://www.dbase.com/Knowledgebase/faq/dBASE_Limits_FAQ.html

Re: Feature for a Dbf archive - Request info to Experts

PostPosted: Thu Oct 28, 2021 6:45 am
by Silvio.Falconi
Marc Venken wrote:Point 2 :

You can have only 1x the same fieldname

What you show is 2x a record name

Point3 : I think 1024 fields

https://www.dbase.com/Knowledgebase/faq/dBASE_Limits_FAQ.html



I saw the link and on that page I see this
Number of fields per table (dBASE for Windows) 1024
but how do i recognize if a dbf is 16 bit or windows mode?