People_db

People_db is a simple program for storing information about people in the database. Information about a person includes First Name, Last Name, Nick Name, Date of Birth, Description, Postal Address, Phone No., Email etc. The source code for the application is available in the Baraha SDK.

Features

• Supports storage of information in Indian languages text. Select the language in the Options dialog box.

• Add/Edit/Delete people in the system.

• Query the database by providing a search string. The search string is a “substring" of certain fields, such as First Name, Last Name, Address, Description and Notes. For example, If you have "Search By" option as FistName = rAja, then you will get a list of all the people whose FirstName contains the string "rAja" in it - such as rAjaNNa, gururAja, etc.

• Display the results in either ascending or descending order of certain fields, such as Person ID, First Name, Last Name, Nick Name, and Telephone No.

• Edit notes for the currently selected person.

• Generate reports in the form of a HTML file. Two types of reports available: "All Address" report creates a HTML file containing all the addresses in the system. You can print this report to produce the address labels for mailing purpose. The "Selected Person" report will have the complete details of the currently selected person.

Options Dialog Box

Language: Is the language in which you want to do the data-entry. Only those records that correspond to the selected language are displayed in the table.

Maximum Rows: If the database has a lot of records, then showing all of them in the table may take a lot of time. This setting specifies the maximum no. of records(rows) to be displayed in the table. You can also use the search option to limit the no. of records returned.

Keyboard Delay: Is the keyboard delay setting in milliseconds. Please refer to Baraha Direct help topic for more information.

Date Fields

The DOB field is a date field. The date can be entered as mm/dd/yyyy format (ex: 08/15/1947). You can also type the name of the month like "15, AgasT 1947". If you improperly type the name of the month, you will get "Invalid Date" error.

Requirements for running the sample application

The following components are required for running the above application. These components may be already installed in your system. If you get any errors running the application, then install the following components,

• You need Baraha 6.0 installed in your system.
• You need Visual Basic 6.0 runtime. You can download the same from Microsoft's website.
• You need MDAC 2.0 or later version installed in you system. You can download the same from http://www.microsoft.com/data/download.htm.
• You need MSFlexGrid (msflxgrd.ocx) and SSTab (tabctl32.ocx) controls installed in your system. You can download the same from here.