Borland Delphi Database Easy Learning

How to work with FUNCTION

2007-10-12T20:41:00.004-07:00

How to work with FUNCTION

To work with FUNCTION

Step 1

Description:

The function is a subprogram called form within an expression that returns a value through the function name.

Declaration:

function ident (parameters) : type;

Example:

function sumofsquares(n: integer): integer;

Edited By: Norasyikin Mahmud
© 2001 ISC
All rights reserved. All other product names and trademarks are registered properties of their respective owners.

051101

How to work with Boolean operators

2007-10-12T20:41:00.003-07:00

How to work with Boolean operators

To work with Boolean operators

Step 1

Description:

Boolean operators are the special operators are use to combine Boolean expressions;

Declaration:

Operator Operation

not negation

and logical and

or logical or

xor logical xor

Example:

if (player1 > player2) or (player1 >= player2) then

Writeln(' The winner is player 1');

if (player1 <>

Writeln(' The winner is player 2');

How to work with relational operators

2007-10-12T20:41:00.001-07:00

How to work with relational operators

To work with relational operators

Step 1

Description:

A sequence of identifiers, separated by compatible operators, that evaluates to TRUE or FALSE

Declaration:

Operator Operation

= Equal

Not equal

Greater than

<= Less or equal

>= Greater or equal

Example:

if player1 > player2 then

Writeln(' The winner is player 1');

if player1 <>

Writeln(' The winner is player 2');

if player1 = player2 then

Writeln(' No winner in this game ');

How to work with Binary Arithmetic Operators

2007-10-12T20:40:00.003-07:00

How to work with Binary Arithmetic Operators

To work with Binary Arithmetic Operators

Step 1

Description:

Arithmetic operators, which take real or integer operands, include +, –, *, /, div, and mod.

Declaration:

Operator Operation

+ Addition

Subtraction

Multiplication

/ Division

div Integer division

mod remainder

Example:

Writeln('Answer is : ',a+b+c);

Writeln('Answer is : ',a*b*c);

Writeln('Answer is : ',a+b-c);

How to work with CASE function

2007-10-12T20:40:00.001-07:00

How to work with CASE function

To work with CASE function

Step 1

Description:

The case statement consists of an expression (the selector) and a list of statements, each prefixed with a case.

Declaration:

case expression of

case: statement;

...

case: statement;

end

Example:

case a of

'm': Writeln('You are the boy');

'f': Writeln('You are the girl');

end;

How to work REPEAT …. UNTIL statement

2007-10-12T20:39:00.003-07:00

How to work REPEAT …. UNTIL statement

To work REPEAT …. UNTIL statement

Step 1

Description:

The statements between repeat and until are executed in sequence until, at the end of a sequence, the Boolean expression is True.

Declaration:

repeat

statement;

...

statement

until expression

Example:

Repeat

y:=(x*x*x+7*x-1)/(x*x-(x+5)/3);

Writeln;

Write(x,'',y);

if y>=0 then Write(' Admit ');

Writeln;

x:=x+0.50

Until x >=4.00;

How to work with FOR …. TO statements

2007-10-12T20:39:00.001-07:00

How to work with FOR …. TO statements

To work with FOR …. TO statements

Step 1

Description:

The FOR statement is a looping construct designed specifically for count-controlled loops.

Declaration:

FOR variable identifier:= Expressionl TO Expression2 DO

Statement 1;

Statement 2;

Example:

for number:=4 to 9 do

begin

sqnumber:=number*number;

Writeln(number,' ',sqnumber)

End

How to work with WHILE statement

2007-10-12T20:38:00.001-07:00

How to work with WHILE statement

To work with WHILE statement

Step 1

Description:

The while statements like the IF statements, tests a condition.

Declaration:

WHILE Boolean expression DO

Statements 1;

Statements 2;

Example:

While x <=4.00 do

begin

y:=(x*x*x+7*x-1)/(x*x-(x+5)/3);

Writeln;

Write(x,'',y);

if y>=0 then Write(' Admit ');

Writeln;

x:=x+0.50

end;

How to work with IF…….THEN……ELSE statement

2007-10-12T20:37:00.003-07:00

How to work with IF…….THEN……ELSE statement

To work with IF…….THEN……ELSE statement

Step 1

Description:

The ability in make decisions.

Declaration:

IF Boolean expression

THEN

Statements 1

ELSE

Statements 2;

Statements;

Example:

if a > 10 Then

Writeln(' This integer is more then 10')

Else

Writeln(' This integer is small then 10');

How to work with IF…..THEN statement

2007-10-12T20:37:00.001-07:00

How to work with IF…..THEN statement

To work with IF…..THEN statement

Step 1

Description:

The ability to make decisions.

Declaration:

IF Boolean expression

THEN

Statements 1;

Statements 2;

Example:

if a > 10 Then

Writeln(' This interger is more then 20');

How to work with record

2007-10-12T20:36:00.003-07:00

How to work with record

To work with record

Step 1

Description:

The components of a record are called fields. Each field has its own field identifier and type

Example:

type

student=record

StudentNo:longint;

StudentName:string;

Department:string;

end;

How to work with array

2007-10-12T20:36:00.001-07:00

How to work with array

To work with array

Step 1

Description:

Array is a structured group of like elements given a common name.

Declaration:

array [index-type] of element-type

Example:

var

mark:array [1..40] of integer;

How to work with real type

2007-10-12T20:35:00.003-07:00

How to work with real type

To work with real type

Step 1

Description:

A real type defines a set of numbers that can be represented with floating-point notation.

Declaration:

Type Range

Real48 2.9 x 10^–39 .. 1.7 x 10^38

Single 1.5 x 10^–45 .. 3.4 x 10^38

Double 5.0 x 10^–324 .. 1.7 x 10^308

Extended 3.6 x 10^–4951 .. 1.1 x 10^4932

Comp –2^63+1 .. 2^63 –1

Currency –922337203685477.5808.. 922337203685477.5807

Example:

var

a:double;

b:single;

How to work with string

2007-10-12T20:35:00.001-07:00

How to work with string

To work with string

Step 1

Description:

A string represents a sequence of characters.

Declaration:

Type Maximum length

ShortString 255 characters 2 to 256 bytes

AnsiString ~2^31 characters

WideString ~2^30 characters

Example:

var

a:string;

How to work with char

2007-10-12T20:34:00.002-07:00

How to work with char

To work with char

Step 1

Description:

Delphi has three character types: Char, AnsiChar, and WideChar.

Declaration:

Type Contents

Char A single character

AnsiChar A single character

WideChar A single Unicode character

Example:

var

a:char;

How to work with Boolean

2007-10-12T20:34:00.001-07:00

How to work with Boolean

To work with Boolean

Step 1

Description:

The four predefined Boolean types are Boolean, ByteBool, WordBool, and LongBool. Boolean is the preferred type.

Declaration:

Boolean ByteBool, WordBool, LongBool

False <> True

Ord(False) = 0 Ord(False) = 0

Ord(True) = 1 Ord(True) <> 0

Succ(False) = True Succ(False) = True

Pred(True) = False Pred(False) = True

Example:

if X <> 0 then ...;

var OK: Boolean

...

if X <> 0 then OK := True;

if OK then ...;

How to work with integer types

2007-10-12T20:32:00.003-07:00

How to work with integer types

To work with integer types

Step 1

Description:

Fundamental integer types include Shortint, Smallint, Longint, Int64, Byte, Word, and Longword.

Declaration:

Type Range

Shortint –128..127

Smallint –32768..32767

Longint –2147483648..2147483647

Int64 –2^63..2^63–1

Byte 0..255

Word 0..65535

Longword 0..4294967295

Example:

var

a:integer;

b:integer;

c:integer;

How to add the item in the DBCombolBox

2007-10-12T20:32:00.001-07:00

How to add the item in the DBCombolBox

To add the item in the DBCombolBox

Step 1

To add the item in the DBCombolBox, first, you need to click the Items properties.

Step 2

After that, insert the Item and finally, click the Ok button.

How to add the DBComboBo

2007-10-12T20:31:00.002-07:00

How to add the DBComboBo

To add the DBComboBo

Step 1

To add the DBComBo, first, you need to move the mouse to the Data Control object toolbar and then click the DBComboxBo object.

Step 2

Now, you have to insert the DBComboBox in the Form1.

Step 3

Next, you need to select the DataSource and then select the Department in the DataField.

How to create the gender with checkbox

2007-10-12T20:31:00.001-07:00

How to create the gender with checkbox

To create the gender with checkbox

Step 1

If you would like to create the gender with checkbox, first, double click the CheckBox1 and it will display a Code Explorer Window. Next, you need to insert the programming as followed;

dbcheckbox1.Checked:=not checkbox1.Checked;
table1.Edit;
dbcheckbox1.Field.AsVariant:=dbcheckbox1.Checked;

How to create the gender with checkbox

2007-10-12T20:30:00.004-07:00

How to create the gender with checkbox

To create the gender with checkbox

Step 1

To create the gender with checkbox, first you need to double click the DBCheckBox1 and then it will display a Code Explorer Window. Next, you need to insert the programming as followed;

checkbox1.Checked:=not dbcheckbox1.Checked;

How to create the gender with checkbox

2007-10-12T20:30:00.003-07:00

How to create the gender with checkbox

To create the gender with checkbox

Step 1

To create the gender with checkbook, first, you need to double click the From1 and then it will display a Code Explorer Window. Later you need to insert the programming as followed;

Table1.Active:=True;
checkbox1.Checked:=not dbcheckbox1.Checked;

How to create the gender with checkbox

2007-10-12T20:30:00.001-07:00

How to create the gender with checkbox

To create the gender with checkbox

Step 1

To create the gender with checkbook, first, move the mouse to the Standard object toolbar and then click the CheckBox object.

Step 2

After that, you need to insert the CheckBox in the Form1.

Step 3

Later, you need to enter the Female in the Caption.

How to create the gender with CheckBox

2007-10-12T20:29:00.003-07:00

How to create the gender with CheckBox

To create the gender with CheckBox

Step 1

If you wish to create the gender with CheckBox, the first thing you need to do is to move the mouse to the Data Controls object toolbar and then click the DBCheckBox object.

Step 2

Next, you have to insert the DBCheckBox in the Form1.

Step 3

Later, select the DataSource and select the Gender in the DataField.

How to create the Department with Edit box

2007-10-12T20:29:00.001-07:00

How to create the Department with Edit box

To create the Department with Edit box

Step 1

To create the Department with Edit box, first you need to move the mouse to the Data Controls object toolbar and then click the DBEdit object.

Step 2

Next, you have to insert the DBEdit in the Form1.

Step 3

Then, select the DataSource and select the Department in the DataField.

How to create the student name with Edit box

2007-10-12T20:28:00.004-07:00

How to create the student name with Edit box

To create the student name with Edit box

Step 1

To create the student name with Edit box, first, you need to move the mouse to the Data Controls object toolbar and then click the DBEdit object.

Step 2

Next, you need to insert the DBEdit in the Form1.

Step 3

After that, select the DataSource and select the StudentName in the DataField.

How to create the student id with Edit box

2007-10-12T20:28:00.003-07:00

How to create the student id with Edit box

To create the student id with Edit box

Step 1

To create the student id with Edit box, first, you need to move the mouse to the Data Controls object toolbar and then click the DBEdit object.

Step 2

Next, you need to insert the DBEdit in the Form1.

Step 3

Later, select the DataSource and then select the StudentID in the DataField.

How to create the Search button

2007-10-12T20:28:00.001-07:00

How to create the Search button

To create the Search button

Step 1

To create the search button, the first thing you need to do is to add the Button in the Form1 and then rename the Caption to Search.

Step 2

Next, just double click the Button to show the Code Explorer Window and then set the Program as followed;

var
idno:string;
find:boolean;
begin
idno:=inputbox(' Enter the Stuent No',
' Enter the No ','9732001');
Table1.SetKey;
Table1.Fields[0].AsString:=idno;
find:=table1.GotoKey;
if not find then
ShowMessage(' No this Record ');
end;

How to create the Delete button

2007-10-12T20:27:00.003-07:00

How to create the Delete button

To create the Delete button

Step 1

To create the Delete button, first, add the Button in the Form1 and then rename the Caption to Delete.

Step 2

Next, just double click the Button to show the Code Explorer Window and you need to set the Program as followed;

Table1.Delete;
procedure TForm1.Table1BeforeDelete(DataSet:TDataSet);
begin
if messagedlg(' You want delete the data ',mtinformation,[mbyes,mbno],0)

=mrno then abort();

end;

Step 3

Now, you need type and insert the code and set the Program as followed;

procedure Table1BeforeDelete(DataSet: TDataSet);

How to create the Add Record button

2007-10-12T20:27:00.001-07:00

How to create the Add Record button

To create the Add Record button

Step 1

To create the Add Record button, first, add the Button in the Form1 and then rename the Caption to Add Record.

Step 2

Double click the Button to show the Code Explorer Window and then set the Program as followed;

Table1.Append;

How to create the Last Record button

2007-10-12T20:26:00.004-07:00

How to create the Last Record button

To create the Last Record button

Step 1

To create the last record button, first, add the Button in the Form1 and then rename the Caption to Last Record.

Step 2

Next, you have to double click the Button to show the Code Explorer Window and you need to set the Program as followed;

Table1.Last;

How to create the Next record button

2007-10-12T20:26:00.003-07:00

How to create the Next record button

To create the Next record button

Step 1

To create the Next button, first, add the Button in the Form1 and then rename the Caption to Next.

Step 2

Next, double click the Button to show the Code Explorer Window and then you need to set the Program as followed;

Table1.Next;

How to create the Previous button

2007-10-12T20:26:00.001-07:00

How to create the Previous button

To create the Previous button

Step 1

To create the previous button, first you need to add the Button in the Form1 and then rename the Caption to Previous.

Step 2

After that, double click the Button to show the Code Explorer Window and you need to set the Program as followed;

Table1.Prior;

How to create the Go To First button in the database

2007-10-12T20:25:00.004-07:00

How to create the Go To First button in the database

To create the Go To First button in the database

Step 1

To create the Go To First button in the database, first, you need to add the Button in the Form1 and then rename the Caption to First Record.

Step 2

Next, you need to double click the Button to show the Code Explorer Window. And you need to set the Program as followed:

Table1.First;

How to create the master or detail form

2007-10-12T20:25:00.003-07:00

How to create the master or detail form

To create the master or detail form

Step 1

To create the master or detail form, first, you need to open the Database menu and then click the Form Wizard command.

Step 2

Next, in the From Option, select the Create a master/detail form and click the Next button.

Step 3

Now, you must select the master table that you want and click the Next button.

Step 4

Then, select the field that you want and later, click the Next button. You just need to follow the step by step wizard to finish it.

Step 5

Select the detail table that you want and click the Next button.

Step 6

Later, select the field that you want and then click Next button. You just need to follow the step by step wizard to finish it.

Step 7

Finally, you have finished and the picture below appears on your screen.

How to use the From Wizard to create the simple form

2007-10-12T20:25:00.001-07:00

How to use the From Wizard to create the simple form

To use the From Wizard to create the simple form

Step 1

To use the From Wizard to create the simple form, first, you need to open the Database menu and then click the Form Wizard command.

Step 2

Next, in the From Option select the Create a simple form and then click the Next button.

Step 3

Later, you need to select the table that you want and then click the Next button.

Step 4

Now, select the field that you want and click the Next button. All you need to do is to follow the wizard, step by step finish it.

Step 5

Now, the Simple form appears on your screen.

How to create the Exit button in this program

2007-10-12T20:24:00.003-07:00

How to create the Exit button in this program

To create the Exit button in this program

Step 1

To create the exit button in this program, first, you need to insert the Button in the From1 and then enter the Exit word on the button.

Step 2

Next, you need to double click the button and write down the programming in the Code Explorer Window.

Step 3

Finally, you need to set the following;

Program:
Table1.Active := false;
Close;

How to use the TDBGrid to view the table

2007-10-12T20:24:00.001-07:00

How to use the TDBGrid to view the table

To use the TDBGrid to view the table

Step 1

To use the TDBGrid to view the table, first, you need to move the mouse to the Data Controls object toolbar and then click the TDBGrid object.

Step 2

After that, inserts the TDBGrid to the From1.

Step 3

Now, you need to go to Object Inspector window to modify the properties and then find the DataSource in the window and then select the DataSource that you want.

How to use the TDataSource to link the table

2007-10-12T20:23:00.004-07:00

How to use the TDataSource to link the table

To use the TDataSource to link the table

Step 1

To use the TdataSource to link the table, the first thing you need to do is to move the mouse to the Data Access object toolbar and then click the TDataSource object.

Step 2

Next, you need to insert the TDataSource in the From1.

Step 3

Later, you need to go to Object Inspector window to modify the properties and then find the DatabaseSet in the window and then select the Table that you want. After that, set the Active to the True.

How to use the TTable object to link the database

2007-10-12T20:23:00.003-07:00

How to use the TTable object to link the database

To use the TTable object to link the database

Step 1

To use the Ttable object to link the database, first, you need to move the mouse to the BDE object toolbar and then click the TTable object.

Step 2

After that, insert the TTable in the Form1.

Step 3

Now, you need to go to Object Inspector window to modify the properties and then find the DatabaseName in the window and then select the database that you want. Next, find the TableName in the window and then select the table. After that, set the Active to the True.

How to rename the Alias

2007-10-12T20:23:00.001-07:00

How to rename the Alias

To rename the Alias

Step 1

To rename the Alias, first you need to select the Alias that you want to rename.

Step 2

Next, you need to Right click the mouse key and then click the Rename command.

Step 3

Now, enter the new Name and Save the new alias. After that, exit the BDE Administrator.

How to use the BDE Administrator to create the Alias

2007-10-12T20:22:00.004-07:00

How to use the BDE Administrator to create the Alias

To use the BDE Administrator to create the Alias

Step 1

To use the BDE Administrator to open the Object menu and then click the New command.

Step 2

Next, you have to select the Database Driver Name where, the Standard is Paradox 7.0 ant click the Ok button.

Step 3

Later, you must click the Path button and select the table that you want to create the Alias. Next, click the Ok button.

How to insert the new data

2007-10-12T20:22:00.003-07:00

How to insert the new data

To insert the new data

Step 1

To insert the new data, first select the place where you want to insert the new data.

Step 2

Later, open the Record menu and then click the Insert command.

Step 3

You will see a new data is being inserted in the table.

How to delete the data

2007-10-12T20:22:00.001-07:00

How to delete the data

To delete the data

Step 1

To delete the date, the first thing you must do is to select the data, which you want to delete it.

Step 2

Next, open the Record menu and then click the Delete command.

Step 3

Later, you will see the data is deleting.

How to insert the new field in the table

2007-10-12T20:21:00.005-07:00

How to insert the new field in the table

To insert the new field in the table

Step 1

To insert the new field in the table, first, you need to open the Table menu and then click the Restructure command.

Step 2

Next, it will display the Table Editor dialog box and then you need to enter the new field in the table. Later, just click the Save button.

Step 3

Now, you will see the new field is being inserted in the table.

How to work with the database navigator

2007-10-12T20:21:00.003-07:00

How to work with the database navigator

To work with the database navigator

Step 1

To work with the database navigator, the first thing you need to do is to move the mouse to the toolbar and you will see the navigator bar.

Step 2

Now, you need to do the following;

Go to First data
Go to Fist page First data
Go Back
Go to Next
Go to Next page First data
Go to End data

How to input the data in the table

2007-10-12T20:21:00.001-07:00

How to input the data in the table

To input the data in the table

Step 1

To input the date in the table, first, you need to open the Table menu and then click the Edit Data command.

Step 2

Now, you can start to enter the data in the table, which indicates True as male and False as female.

How to create the primary key in the table

2007-10-12T20:20:00.003-07:00

How to create the primary key in the table

To create the primary key in the table

Step 1

To create the primary key in the table, at the key column, you need to insert the * to specify the primary key and after that, click the Save As button.

Step 2

Next, you must enter the File name and click the Save button.

How to create the table by example

2007-10-12T20:20:00.001-07:00

How to create the table by example

To create the table by example

Step 1

To create the table by example, first, you need to create the Student ID, Student Name, and Gender in the table, as example. This is how we need to type it, as shown in the picture. After that, you need to click the Save As button to save the table.

Step 2

After that, you need to enter the File name and click the Save button.

How to use the Database Desktop to create the table

2007-10-12T20:19:00.002-07:00

How to use the Database Desktop to create the table

To use the Database Desktop to create the table

Step 1

To use the Database Desktop to create the table and then you need to open the File menu and then open the New sub menu. Next, you need to click the Table command.

Step 2

After that, you need to select the Table type that you want and click the Ok button.

Step 3

Later, it will display a Table editor dialog box and you ought to enter the Field Name, Type, Size.

How to use the Template to set up Mainmenu

2007-10-12T20:19:00.001-07:00

How to use the Template to set up Mainmenu

To use the Template to set up Mainmenu

Step 1

To use the template to set up mainmenu, at the MenuDesigner dialog, youhave to Right click the mouse key and then click the Insert From Template command.

Step 2

Next, select the menu that you want.

Step 3

Now, the menu is automatic clicked.

How to design the popup menu

2007-10-12T20:18:00.004-07:00

How to design the popup menu

To design the popup menu

Step 1

To design the popup menu, first, you need to Right click the mouse key and it will display a popup menu. After that, you need to click the Menu Designer command.

Step 2

Now, you can start to design the Main menu.

Step 3

Later, you must go to the From1 properties and find the PopupMenu properties and then select the PopupMenu name.

Step 4

Finally, the Popupmenu appears on your screen.

How to create the popup menu

2007-10-12T20:18:00.003-07:00

How to create the popup menu

To create the popup menu

Step 1

To create the popup menu, first, move the mouse to the Standard object tool bar and then click the Popup menu object.

Step 2

Later, add the Popup menu object in the form.

Step 3

Now, you can edit the Popup menu properties.

How to create programming in the Exit command

2007-10-12T20:18:00.001-07:00

How to create programming in the Exit command

To create programming in the Exit command

Step 1

To create programming in the Exit command, the first thing you need to do is to left click the mouse button and then you’re at .the Exit command.

Step 2

Next, it will display a code editor window and you need to enter the programming in the window.

Step 3

Now, you need to do the following for the Programming:

procedure TForm1.Exit1Click(Sender: TObject);
begin
Close;
end;
end.

This command is used to close the form.

How to create the shortcut in the main menu

2007-10-12T20:17:00.004-07:00

How to create the shortcut in the main menu

To create the shortcut in the main menu

Step1

To create the shortcut in the main menu, first you need to select the command that you want to create shortcut.

Step 2

Next, in the Object Inspector window, you need to find the Shortcut command and after that, select the shortcut.

Step 3

Now, the shortcut is in the main menu.

How to create the line in the File menu

2007-10-12T20:17:00.003-07:00

How to create the line in the File menu

To create the line in the File menu

Step 1

If you wish to create the line in the File menu, the first thing you need to do is to find the Caption command the Object Inspector window. After that, enter the -.

Step 2

Then, you will see the line in the menu.

How to create the File menu

2007-10-12T20:17:00.001-07:00

How to create the File menu

To create the File menu

Step1

To create the File menu, at the Object Inspector window, you need to find the Caption command and then enter the name.

Step 2

Now, you can start to create the File menu.

How to create the design menu

2007-10-12T20:16:00.003-07:00

How to create the design menu

To create the design menu

Step 1

To create the design menu, first you need to right click the mouse key and it will display a popup menu. After that, you need to click the Menu Designer command.

Step 2

Now, you can start to design the Main menu.

Borland Delphi 6.0 for Database

2007-10-12T20:16:00.001-07:00

Borland Delphi 6.0 for Database

Delphi 6.0 for Database features compiler-level support for SOAP (Simple Object Access Protocol) and WSDL (Web Services Description Language). That means programmers will be able to Web-enable their applications without writing extra code. Let's learn how to work with Borland Delphi 6.0 for Database now.

How to create the Main menu

To create the Main menu

Step 1

To create the Main menu, first, you need to move the mouse to the Standard object tool bar and then click the Main menu object.

Step 2

After that, add the Main menu object in the form.

Step 3

You can start to modify Main menu properties, now.