FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Feature for a Dbf archive - Request info to Experts
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Feature for a Dbf archive - Request info to Experts
Posted: Mon Oct 25, 2021 11:21 AM
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)



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?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 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
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: Feature for a Dbf archive - Request info to Experts
Posted: Wed Oct 27, 2021 07:51 PM
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
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: Feature for a Dbf archive - Request info to Experts
Posted: Thu Oct 28, 2021 06:45 AM
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 March-April 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

Continue the discussion