DDH Software, LLC 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 5 / Total* 1903
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 9 / Total* 3831
Note:MAC Users will need to enter the filename day_of_the_week.zip when saving this file.
* since October 1, 2000.

If, then, else routine

Author:George Wakefield [Send Author Email]
Homepage:
Date
Added:
Updated:

October 31, 2016
November 05, 2016
Description:shows how if then else statements can be constructed
Has Data:Yes
Has Forms:Yes
Comments:I tried for ages to get the result I wanted for one of my HanDbse programmes. I put in here so it would not be lost. I hope someone finds it useful.
Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:if_then_else.pdb          Downloads: This Month 11 / Total* 3531
Note:MAC Users will need to enter the filename if_then_else.pdb 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 344 / Total* 16303
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 3 / Total* 2624
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 13 / Total* 6733
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 314 / Total* 15943
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 3 / Total* 1580
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 15 / Total* 2949
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 10 / Total* 2811
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 325 / Total* 23833
Note:MAC Users will need to enter the filename relationship_linking.zip when saving this file.
* since October 1, 2000.

RGB Calculator

Author:George Sokol [Send Author Email]
Homepage:
Date
Added:

January 16, 2022
Description:This app is designed for developers and graphic artists that want a quick way to calculate the RGB values for shading or tinting colors in their design. It provides both several pre-set calculations (25%, 50%, 75%) as well as the ability to enter your own percentage factor to create a custom calculation. To use this app: - Follow instructions in readme to install. - Create a new record, labeling it something descriptive such as "Dark Green" or "Background Color for my form" in the Description field. - Enter the R, G, B numbers at the top of the form. - If desired, enter the desired factor in the Factor field. Calculations should be automatic. There is a special feature to copy any of the calculated RGB values - just tap on the color band of the color you wish. Just note that this uses HanDBase's External-Combine Text feature so you should only do this after saving the form - otherwise it will copy the previous result.
Has Data:Yes
Has Forms:Yes
Price:FREE
Version:HanDBase v.4.x Enhanced or greater
File:rgb_calc!_hdf.zip          Downloads: This Month 119 / Total* 1715
Note:MAC Users will need to enter the filename rgb_calc!_hdf.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 327 / Total* 16446
Note:MAC Users will need to enter the filename moviesactors.zip when saving this file.
* since October 1, 2000.