Feature for a Dbf archive - Request info to Experts

Feature for a Dbf archive - Request info to Experts

Postby Silvio.Falconi » 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)

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
Silvio.Falconi
 
Posts: 7063
Joined: Thu Oct 18, 2012 7:17 pm

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

Postby Marc Venken » Wed Oct 27, 2021 7: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.04 with Harbour
User avatar
Marc Venken
 
Posts: 1434
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

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

Postby Silvio.Falconi » Thu Oct 28, 2021 6: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 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
Silvio.Falconi
 
Posts: 7063
Joined: Thu Oct 18, 2012 7:17 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 106 guests