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
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
To set TDBNavigator properties
Data Source = Use the Data Source property to link the database navigator with a data set.
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
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:
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
To set the TDataSource properties
Data Set = The name of an existing data set component, either at design time or at runtime.
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
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.
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
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
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:
To delete the Record
Step a: Select the record that you want to delete
Step b: Got to Record>Delete
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
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
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.
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.
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.
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.
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.
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.