Friday, October 5, 2007

How to work with TDBNavigator

How to work with TDBNavigator

To work with TDBNavigator

= Go to First Record

= Previous Record

= Go to Next Record

= Go to Last Record

= Add New Record

= Remove the Record

= Edit the Record

= Post

= Cancel

= Refresh

How to set TDBNavigator properties

How to set TDBNavigator properties

To set TDBNavigator properties

Data Source = Use the Data Source property to link the database navigator with a data set.

How to work with the TDBNavigator object

How to work with the TDBNavigator object

To work with the TDBNavigator object

Step a: Go to Data Control Components bar

Step b: Select the TDBGrid Object

Step c: Add to the Form1

How to set the TDBGrid properties

How to set the TDBGrid properties

To set the TDBGrid properties

Data Source = The TDataSource object that links to the data set, where the data-aware grid should fetch its data.

Step a: This will display on the form like this:

How to work with TDBGrid object

How to work with TDBGrid object

To work with TDBGrid object

Step a: Go to Data Control Components bar

Step b: Select the TDBGrid Object

Step c: Add to the Form1

How to set the TDataSource properties

How to set the TDataSource properties

To set the TDataSource properties

Data Set = The name of an existing data set component, either at design time or at runtime.

How to work with the TDataSource

How to work with the TDataSource

To work with the TDataSource

Step a: Go to Data Access Components bar

Step b: Select the TDataSource Object

Step c: Add to the Form1

How to set the TTable Object properties

How to set the TTable Object properties

To set the TTable Object properties

Active = To open the table or close the table. If you want to open the table, set it to True, or close the table by setting False.

Database Name = The database name that you want to choose.

Table Name = To select the table name.

How to create the TTable Object

How to create the TTable Object

To create the TTable Object

Step a: Go to Data Access Components bar

Step b: Select the TTable Object

Step c: Add to the Form1

How to create a new Alias

How to create a new Alias

To create a new Alias

Step a: Go to Object>New

Step b: This will display a New Database Dialog box

Step c: Select the Database Drive Name

Step d: Click ‘OK’ button

Step e: Use the mouse to click on the PATH

Step f: Use the mouse to click on the icon

Step g: This will display the dialog box

Step h: Select the drive.

Step i: Select the Directories

step j: Click the ‘OK’ button

How to Open the BDE Administrator

How to Open the BDE Administrator

To Open the BDE Administrator

Step a: Go to window Control Panel

Step b: select the BDE Administrator icon and double click on it.

Step c: This will display a window like this:

How to delete the Record

How to delete the Record

To delete the Record

Step a: Select the record that you want to delete

Step b: Got to Record>Delete

How to Add the Record to the Table

How to Add the Record to the Table

To Add the Record to the Table

Step a: Go to standard menu bar

Step b: Click the

Step c: Enter your data in the field

How to Open the Table on Database

How to Open the Table on Database

To Open the Table on Database

Step a: Go to Open>Table

Step b: This will display anOpen dialog box

Step c: Select the Table you want to open

Step d: Click ‘Open’ button

How to work with the new table on Database

How to work with the new table on Database

To work with the new table on Database

Step a: Enter the Data into the Table

Field Name

Type

Size

Key

REP_NO

A

8

*

REP_NAME

A

40

REP_IMG

O

REP_COPY

N

REP_UNIT

A

4

Step b: Cick ‘Save As’ button

Step c: This will display the ‘Save Table As’ dialog box

Step d: Enter the file nme and setting the alias

Step e: Cick the ‘Save’ button.

How to work with Database Desktop to create a new Table

How to work with Database Desktop to create a new Table

To work with Database Desktop to create a new Table

Step a: Go to New>Table

Step b: select the Table Type

Step c: click ‘OK’ button

Step d: This will display a window that allows you to create a new table.

How to Open the Database Desktop

How to Open the Database Desktop

To Open the Database Desktop

Using Database

Step a: Go to Tools>Database Desktop

Step b: This will show the Database Desktop program on your screen to allow you to design your Delphi database.

How to delete the Template

How to delete the Template

To delete the Template

Step a: Right click on the mouse and select the Delete template.

Step b: This will allow you to delete the menu template from the form.


How to insert Template to the Pop Up menu

How to insert Template to the Pop Up menu

To insert Template to the Pop Up menu

Step a: Right click the mouse key and select the ‘Insert From Template’.

Step b: Select a template that you want to use.

Step c: Click ‘OK’ button.

How to create the Pop Up Menu

How to create the Pop Up Menu

To create the Pop Up Menu

Step a: Go to Components bar and select the standard Main Menu icon.

Step b: Click the mouse button on the Form to add the Pop Up menu to the form.

Step c: Right click on the mouse and it will display a menu. Select Menu Designer.

Step d: Enter the name into the caption field.