Feature for a Dbf archive - Request info to Experts

Post Reply
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Feature for a Dbf archive - Request info to Experts

Post 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
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Marc Venken
Posts: 1485
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

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

Post 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
Marc Venken
Using: FWH 23.08 with Harbour
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

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

Post 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?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Post Reply