Maximum No of Records - Plus Unique Field Type

Discuss plans for a future version of HanDBase for the Google Android platform

Maximum No of Records - Plus Unique Field Type

Postby MidlandDeltic » Mon Mar 25, 2019 8:12 am

Hi

A couple of related issues. Firstly I cannot find a figure for the maximum number of records in a single database. The fact that the unique field type only goes up to 65536 suggests that is the limit. Can you confirm please?

While mentioning the Unique Field type, can you confirm how this works please? In Palm I seem to recall that the number was unique across all databases, and thought this appeared to be the case on Android. However, when cross referencing data recently, I find that I have duplicated "unique" numbers in different databases, despite them being getting different number blocks to start with when the Unique field was set up. Is there any way I can force unique numbers across all databases? The toal number if records is approaching thay apoarent 65k limit ;)

Thanks

Sean

Sent from my 5099Y using Tapatalk
MidlandDeltic
 
Posts: 13
Joined: Tue Jan 10, 2012 6:39 am

Re: Maximum No of Records - Plus Unique Field Type

Postby ddhsoftwareadmin » Sat Mar 30, 2019 12:58 pm

Hi Sean,

Thanks for writing. The max number of records are 65000 per database. The unique field is unique only within the current database- the unique counter is kept as part of the database structure, and it is shared among all fields in that database. So if you have 3 unique fields, you'll notice it increasing by 3 for each record you add!

Hope this helps.
ddhsoftwareadmin
Site Admin
 
Posts: 386
Joined: Tue Dec 09, 2008 2:13 pm

Re: Maximum No of Records - Plus Unique Field Type

Postby MidlandDeltic » Sun Mar 31, 2019 9:18 am

Thanks David. I may need to review my database structure, as there are (currently) over 10000 records, and each has a series of "history" records in a daughter database which can be up 15 or more per record (eg new, change owner, reregistration, scrapping). A pity as I wanted to retain all history events in one database for each category I record to allow a view of the complete history in a single link.

BTW, can you clarify what counts as a unique field please? In the database I am currently expanding, it is indeed incrementing three for each record, but I only have one field set as the Unique type. Of 32 fields, there are DB Pop Up (5), Text (11), Check Box (3), Date (3), Pop Up (5) Link (2), Linked (1), Unique (1), and Integer (1).

Many thanks.

Regards

Sean
MidlandDeltic
 
Posts: 13
Joined: Tue Jan 10, 2012 6:39 am

Re: Maximum No of Records - Plus Unique Field Type

Postby mjhanna » Sun Mar 31, 2019 7:00 pm

Sean,

I am not sure exactly what you are trying to do, but it is possible HanDBase's "unique" field type may not a good candidate for doing something like what you are trying to do with daughter databases. I suggest you read the (old) Forum thread about "Automatically generating a Unique, Static, "Key" field" which I started here some time back. Be sure to read the entire thread as Dave and Brian both replied with some warnings and issues concerning the method I described. However, if you understand those warnings I think it might be a way to generate a unique "Record Number" which can be used across your main and daughter databases for each of your records.

Hope this gives you ideas,
Michael
(Only a user and not affiliated with DDH Software, but working with computer databases for over fifty years.)
mjhanna
 
Posts: 164
Joined: Tue Oct 15, 2013 10:56 am
Location: New Mexico


Return to HanDBase for Android

Who is online

Users browsing this forum: No registered users and 1 guest