DDH Software, Inc Making a big world smaller






BetaTest

Author:Dan Perez [Send Author Email]
Homepage:
Date
Added:

April 30, 2002
Description:Applet template from which to maintain developer-specific beta testing issues. Includes a template for use with PocketReport so as to be able to maintain AND send all relevant data from the pilot.
Has Data:No
Has Forms:No
Price:FREE
Version:HanDBase v.2.7x or greater
File:betatest.zip          Downloads: This Month 8 / Total* 1087
Note:MAC Users will need to enter the filename betatest.zip when saving this file.
* since October 1, 2000.

Day of the Week Example

Author:Roberto Machorro [Send Author Email]
Homepage:
Date
Added:

August 28, 2002
Description:Example applet that shows how to display the day of the week (Sunday .. Saturday) on a Text field based on the date in a Date field.
Has Data:Yes
Has Forms:No
Comments:Please refer to the Knowledgebase article for more information.
Price:FREE
Version:HanDBase v.3.0x or greater
File:day_of_the_week.zip          Downloads: This Month 11 / Total* 2624
Note:MAC Users will need to enter the filename day_of_the_week.zip when saving this file.
* since October 1, 2000.

Jump to Form in Other DB Example

Author:David Devaney, Jr. [Send Author Email]
Homepage:http://www.ddhsoftware.com
Date
Added:

February 04, 2010
Description:This applet is a completed sample from Tutorial 10: Jumping from the Form of one database to the form of a different database. The files in this Applet show how the databases should look and function once the Tutorial is complete.
Has Data:Yes
Has Forms:Yes
Comments:To read the Tutorial associated with this Applet visit:

Palm OS - http://www.ddhsoftware.com/knowledgebase.html?read=302

Windows Mobile - http://www.ddhsoftware.com/knowledgebase.html?read=303

Windows Desktop - http://www.ddhsoftware.com/knowledgebase.html?read=304

Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:jumpformotherdb.zip          Downloads: This Month 19 / Total* 2581
Note:MAC Users will need to enter the filename jumpformotherdb.zip when saving this file.
* since October 1, 2000.

Library

Author:Artur Penedo [Send Author Email]
Homepage:
Date
Added:

February 19, 2013
Description:These are my first steps in building a relational database in HanDbase. There are two databases: - Library - Library details (this is the linked database, to control lending and returning of books) The circa 430 books are actually my books. By the way, it was so funny to review and populate the database, because I "discovered" a lot of books that I thought were lost... If I click on a book in list book, it goes to the details database and show this book's lending s, pending or complete. Or shows nothing if there are no lendings. I have now to test everything to see the hiden bugs. The English translation was just made to send to you
Has Data:Yes
Has Forms:No
Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:library.zip          Downloads: This Month 19 / Total* 1842
Note:MAC Users will need to enter the filename library.zip when saving this file.
* since October 1, 2000.

Link Linked Relationship

Author:Roberto Machorro [Send Author Email]
Homepage:
Date
Added:

August 16, 2002
Description:Databases that serve as an example on how to setup a relationship field using a Link/Linked association as the condition fields.
Has Data:No
Has Forms:No
Comments:Please refer to the Knowledgebase Article number 195 for more information.
Price:FREE
Version:HanDBase v.3.0x or greater
File:linklinkedrelationship.zip          Downloads: This Month 15 / Total* 5204
Note:MAC Users will need to enter the filename linklinkedrelationship.zip when saving this file.
* since October 1, 2000.

Month Calculator

Author:Dave Haupert [Send Author Email]
Homepage:http://www.ddhsoftware.com
Date
Added:

February 24, 2012
Description:This database was designed to demonstrate a way to figure out the month of a date field. The concept uses this idea: Take the date and do the following calculation: Date Mod 365.25 That will give you the number of days into the year. 365 days are in a year, but every fourth year is a leap year, so the .25 is added. Now you have a number from 0 to 365. To get the month, you'd have to do a series of conditionals. Something like this: If DateMod field (the calc field above) is greater than 31 then output is February, else January. If DateMod field is greater than 59 then output is March, else output is previous conditional. If DateMod field is greater than 90 then output is April, else output is previous conditional. ... The example has a date field where you can pick a date and then a conditional field that is visible showing the month of the year. A few caveats: 1. It uses up a bunch of hidden calculation and conditional fields. You'll need about 13 extra fields in your database to have room for this. 2. If you are in a leap year (such as now, 2012) the number in the conditional for February onward need to go up by one, as I did not account for the leap day in 2012. On other years, this should work fine as is. 3. September is one character too long for the conditional output, so I abbreviated as Sept You can then select a view to filter based on the month, so you can see all records that fall within the month you're looking at.
Has Data:No
Has Forms:No
Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:month_calculator.pdb          Downloads: This Month 34 / Total* 2145
Note:MAC Users will need to enter the filename month_calculator.pdb when saving this file.
* since October 1, 2000.

My Guru

Author:Moktze [Send Author Email]
Homepage:
Date
Added:

December 19, 2005
Description:As Confucius said there is always a person I can learned from. That is true that my surrounding full of Guru who an give me advice, an internal voices of their opinion, and comment on me, guides me. With this I had created a My GURU to advice me when I got into problem which I need guidance. First of all, a notes to write down your concerned, and the associate factor like what,why,when,who,how and a sketch board for something cannot be written down. Secondly, I have invited my Guru to give their comment, my guru are my father, my admired superior, my friends, my wife, and other guru who will pop up along my live journey. I will be assumed myself in each guru position, and imitate the way they talk and answer question. Notes: 1) It is not necessary that all the guru must give advice. 2) It must not be too formal 3) User can create their own favourate Guru like Stephen corvey , Mahatma Gandhi, or any other great man you admire to sit in circle and give you advice.
Has Data:Yes
Has Forms:No
Filters:NA
Sorting:NA
Reports:NA
Comments:NA
Price:FREE
Version:HanDBase v.3.0x or greater
File:my_guru.pdb          Downloads: This Month 8 / Total* 897
Note:MAC Users will need to enter the filename my_guru.pdb when saving this file.
* since October 1, 2000.

Pseudo Random

Author:Roberto Machorro [Send Author Email]
Homepage:
Date
Added:

February 05, 2003
Description:This is a sample database that shows one of the many ways to generate pseudo-random numbers based of a (Time) seed and a calculation (Calc field). Database developers will find this useful when creating their databases that issue trouble tickets or any kind of custom key.
Has Data:Yes
Has Forms:No
Comments:The database includes a few sample series with specific bounds, please refer to the field (DB Properties) to see how they are setup.
The random number generation is very weak. It's more a sample of things that can be done than a complete solution. Please don't use for encryption or any mission critical function.
Price:FREE
Version:HanDBase v.3.0x or greater
File:pseudo_random.pdb          Downloads: This Month 14 / Total* 1720
Note:MAC Users will need to enter the filename pseudo_random.pdb when saving this file.
* since October 1, 2000.

Random Numbers Databases

Author:Roberto Machorro [Send Author Email]
Homepage:
Date
Added:

August 27, 2003
Description:Several users have requested the databases used to test the Calculation field type. Here you will find 3 large databases we used for testing.
Has Data:Yes
Has Forms:No
Comments:The databases contain the following data:
  1. 30 fields, 2500 rows of random numbers, plus index
  2. 10 fields, 6000 rows of random numbers, plus index
  3. 4 fields, 64000 rows of random numbers, plus index

Price:FREE
Version:HanDBase v.3.0x or greater
File:numbers.zip          Downloads: This Month 13 / Total* 1505
Note:MAC Users will need to enter the filename numbers.zip when saving this file.
* since October 1, 2000.

Relationship Linking Example

Author:David Devaney, Jr. [Send Author Email]
Homepage:www.ddhsoftware.com
Date
Added:
Updated:

April 30, 2004
October 04, 2008
Description:This applet is a set of databases that shows an example of how to use the Relationship field instead of the Link and Linked fields to set up or maintain existing relationships.

This is especially useful when you need to import data from another application and maintain relationships you have set up there.

Has Data:No
Has Forms:No
Comments:The following article in the Knowledgebase discusses how you can maintain existing relationships when you import data, in HanDBase 3.0.

http://www.ddhsoftware.com/knowledgebase.html?read=212

Price:FREE
Version:HanDBase v.3.0x or greater
File:relationship_linking.zip          Downloads: This Month 25 / Total* 9505
Note:MAC Users will need to enter the filename relationship_linking.zip when saving this file.
* since October 1, 2000.

Using Relationships Via Linked Fields

Author:Dave Haupert [Send Author Email]
Homepage:http://www.ddhsoftware.com
Date
Added:

May 02, 2013
Description:This database set is an example of how to bring over multiple fields from a parent table/database to a child using the relationship field. It's a set of databases called Actors and Movies. The main database is actors and there is a first name and last name for each actor. There is a link field to jump to the movies database to show all movies for that actor. The link/linked pair is set up to show the last name from the Actors databases in the Movies database. Normally this is enough to identify the parent record but in this case, the first name should also be shown in case there are two people with the same last name. So then there is a relationship field set up that uses the link/linked as a pair of matching values to grab the first name and show it. You'll see in the setup that the relationship is set to use the: Related Field in this database: Last Name (the linked field) Other Database Name: Actors Field in other database: Movies (the link field of the parent database) Show from other database: First Name (the field we wanted to show here) From Which Record: First matching record. (if the parent database had more than a single match, this setting would let you choose whether to take from the first or last matching record. In this case, there should only be one match since it's a one to many relationship and the 'many' (the movies db) is looking in the 'one' (the actors db) for a match. Thus, in the Movies database, you see both the first name (via the relationship) and the last name (via the Linked field type) for the parent record.
Has Data:Yes
Has Forms:No
Comments:To address topic in forum: http://www.ddhsoftware.com/forum/viewtopic.php?f=16&t=3066
Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:moviesactors.zip          Downloads: This Month 35 / Total* 1989
Note:MAC Users will need to enter the filename moviesactors.zip when saving this file.
* since October 1, 2000.