PWCT 1.9 Art Documentation ( http://doublesvsoop.sourceforge.net )

2006-2013, Mahmoud Fayed ( msfclipper@users.sourceforge.net )

_____________________________________________________________________________________

Table of contents

1 - Introduction

2 - Implementation steps

3 - Final Steps Tree

4 - Application during the runtime

1 - Introduction

In this lesson we are going to learn how to

1 - connect to access database using Microsoft ADO (ActiveX Data Object).

2 - Add new record to a table in our database.

3 - Show table records using a Grid control.

2 - Implementation Steps

s1.JPG

Fig. (1) Goal Desginer - Steps Tree

Select the step (The First Step)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Windows)

                3 - Select the component (Define New Window)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Define New Window)

                Note : Stop typing when you see the required component is selected

s2.JPG

Fig. (2) Component Browser Select the component (Define New Window)

After selecting the component click Ok or press ENTER

s3.JPG

Fig. (3) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s4.JPG

Fig. (4) Form Designer

s5.JPG

Fig. (5) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Image)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Image)

                Note : Stop typing when you see the required component is selected

s6.JPG

Fig. (6) Component Browser Select the component (Image)

After selecting the component click Ok or press ENTER

s7.JPG

Fig. (7) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s8.JPG

Fig. (8) Form Designer

s9.JPG

Fig. (9) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Label)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Label)

                Note : Stop typing when you see the required component is selected

s10.JPG

Fig. (10) Component Browser Select the component (Label)

After selecting the component click Ok or press ENTER

s11.JPG

Fig. (11) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s12.JPG

Fig. (12) Form Designer

s13.JPG

Fig. (13) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Label)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Label)

                Note : Stop typing when you see the required component is selected

s14.JPG

Fig. (14) Component Browser Select the component (Label)

After selecting the component click Ok or press ENTER

s15.JPG

Fig. (15) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s16.JPG

Fig. (16) Form Designer

s17.JPG

Fig. (17) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Label)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Label)

                Note : Stop typing when you see the required component is selected

s18.JPG

Fig. (18) Component Browser Select the component (Label)

After selecting the component click Ok or press ENTER

s19.JPG

Fig. (19) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s20.JPG

Fig. (20) Form Designer

s21.JPG

Fig. (21) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (TextBox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (TextBox)

                Note : Stop typing when you see the required component is selected

s22.JPG

Fig. (22) Component Browser Select the component (TextBox)

After selecting the component click Ok or press ENTER

s23.JPG

Fig. (23) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s24.JPG

Fig. (24) Form Designer

s25.JPG

Fig. (25) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (TextBox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (TextBox)

                Note : Stop typing when you see the required component is selected

s26.JPG

Fig. (26) Component Browser Select the component (TextBox)

After selecting the component click Ok or press ENTER

s27.JPG

Fig. (27) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s28.JPG

Fig. (28) Form Designer

s29.JPG

Fig. (29) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (TextBox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (TextBox)

                Note : Stop typing when you see the required component is selected

s30.JPG

Fig. (30) Component Browser Select the component (TextBox)

After selecting the component click Ok or press ENTER

s31.JPG

Fig. (31) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s32.JPG

Fig. (32) Form Designer

s33.JPG

Fig. (33) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Button)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button)

                Note : Stop typing when you see the required component is selected

s34.JPG

Fig. (34) Component Browser Select the component (Button)

After selecting the component click Ok or press ENTER

s35.JPG

Fig. (35) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s36.JPG

Fig. (36) Form Designer

s37.JPG

Fig. (37) Goal Desginer - Steps Tree

Select the step (Button Events)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Events)

                3 - Select the component (Button Events)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button Events)

                Note : Stop typing when you see the required component is selected

s38.JPG

Fig. (38) Component Browser Select the component (Button Events)

After selecting the component click Ok or press ENTER

s39.JPG

Fig. (39) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s40.JPG

Fig. (40) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Button)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button)

                Note : Stop typing when you see the required component is selected

s41.JPG

Fig. (41) Component Browser Select the component (Button)

After selecting the component click Ok or press ENTER

s42.JPG

Fig. (42) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s43.JPG

Fig. (43) Form Designer

s44.JPG

Fig. (44) Goal Desginer - Steps Tree

Select the step (Button Events)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Events)

                3 - Select the component (Button Events)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button Events)

                Note : Stop typing when you see the required component is selected

s45.JPG

Fig. (45) Component Browser Select the component (Button Events)

After selecting the component click Ok or press ENTER

s46.JPG

Fig. (46) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s47.JPG

Fig. (47) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Grid Control)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Grid Control)

                Note : Stop typing when you see the required component is selected

s48.JPG

Fig. (48) Component Browser Select the component (Grid Control)

After selecting the component click Ok or press ENTER

s49.JPG

Fig. (49) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s50.JPG

Fig. (50) Form Designer

s51.JPG

Fig. (51) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Button)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button)

                Note : Stop typing when you see the required component is selected

s52.JPG

Fig. (52) Component Browser Select the component (Button)

After selecting the component click Ok or press ENTER

s53.JPG

Fig. (53) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s54.JPG

Fig. (54) Form Designer

s55.JPG

Fig. (55) Goal Desginer - Steps Tree

Select the step (Button Events)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Events)

                3 - Select the component (Button Events)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Button Events)

                Note : Stop typing when you see the required component is selected

s56.JPG

Fig. (56) Component Browser Select the component (Button Events)

After selecting the component click Ok or press ENTER

s57.JPG

Fig. (57) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s58.JPG

Fig. (58) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Label)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Label)

                Note : Stop typing when you see the required component is selected

s59.JPG

Fig. (59) Component Browser Select the component (Label)

After selecting the component click Ok or press ENTER

s60.JPG

Fig. (60) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s61.JPG

Fig. (61) Form Designer

s62.JPG

Fig. (62) Goal Desginer - Steps Tree

Select the step (Window Controls)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (TextBox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (TextBox)

                Note : Stop typing when you see the required component is selected

s63.JPG

Fig. (63) Component Browser Select the component (TextBox)

After selecting the component click Ok or press ENTER

s64.JPG

Fig. (64) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s65.JPG

Fig. (65) Form Designer

s66.JPG

Fig. (66) Goal Desginer - Steps Tree

Select the step (The First Step)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Structure Programming)

                3 - Select the component (Define Procedure)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Define Procedure)

                Note : Stop typing when you see the required component is selected

s67.JPG

Fig. (67) Component Browser Select the component (Define Procedure)

After selecting the component click Ok or press ENTER

s68.JPG

Fig. (68) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s69.JPG

Fig. (69) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Windows)

                3 - Select the component (Window Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Window Class)

                Note : Stop typing when you see the required component is selected

s70.JPG

Fig. (70) Component Browser Select the component (Window Class)

After selecting the component click Ok or press ENTER

s71.JPG

Fig. (71) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s72.JPG

Fig. (72) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s73.JPG

Fig. (73) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s74.JPG

Fig. (74) Goal Desginer - Steps Tree

Select the step (The First Step)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Structure Programming)

                3 - Select the component (Define Procedure)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Define Procedure)

                Note : Stop typing when you see the required component is selected

s75.JPG

Fig. (75) Component Browser Select the component (Define Procedure)

After selecting the component click Ok or press ENTER

s76.JPG

Fig. (76) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s77.JPG

Fig. (77) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Connection)

                3 - Select the component (ADO New Connection)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO New Connection)

                Note : Stop typing when you see the required component is selected

s78.JPG

Fig. (78) Component Browser Select the component (ADO New Connection)

After selecting the component click Ok or press ENTER

s79.JPG

Fig. (79) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s80.JPG

Fig. (80) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Connection)

                3 - Select the component (ADO Open Connection)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Open Connection)

                Note : Stop typing when you see the required component is selected

s81.JPG

Fig. (81) Component Browser Select the component (ADO Open Connection)

After selecting the component click Ok or press ENTER

s82.JPG

Fig. (82) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s83.JPG

Fig. (83) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO New RecordSet)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO New RecordSet)

                Note : Stop typing when you see the required component is selected

s84.JPG

Fig. (84) Component Browser Select the component (ADO New RecordSet)

After selecting the component click Ok or press ENTER

s85.JPG

Fig. (85) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s86.JPG

Fig. (86) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Open RecordSet)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Open RecordSet)

                Note : Stop typing when you see the required component is selected

s87.JPG

Fig. (87) Component Browser Select the component (ADO Open RecordSet)

After selecting the component click Ok or press ENTER

s88.JPG

Fig. (88) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s89.JPG

Fig. (89) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Add New Record)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Add New Record)

                Note : Stop typing when you see the required component is selected

s90.JPG

Fig. (90) Component Browser Select the component (ADO Add New Record)

After selecting the component click Ok or press ENTER

s91.JPG

Fig. (91) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s92.JPG

Fig. (92) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Textbox Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Textbox Class)

                Note : Stop typing when you see the required component is selected

s93.JPG

Fig. (93) Component Browser Select the component (Textbox Class)

After selecting the component click Ok or press ENTER

s94.JPG

Fig. (94) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s95.JPG

Fig. (95) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s96.JPG

Fig. (96) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s97.JPG

Fig. (97) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Textbox Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Textbox Class)

                Note : Stop typing when you see the required component is selected

s98.JPG

Fig. (98) Component Browser Select the component (Textbox Class)

After selecting the component click Ok or press ENTER

s99.JPG

Fig. (99) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s100.JPG

Fig. (100) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s101.JPG

Fig. (101) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s102.JPG

Fig. (102) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Textbox Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Textbox Class)

                Note : Stop typing when you see the required component is selected

s103.JPG

Fig. (103) Component Browser Select the component (Textbox Class)

After selecting the component click Ok or press ENTER

s104.JPG

Fig. (104) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s105.JPG

Fig. (105) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s106.JPG

Fig. (106) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s107.JPG

Fig. (107) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Textbox Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Textbox Class)

                Note : Stop typing when you see the required component is selected

s108.JPG

Fig. (108) Component Browser Select the component (Textbox Class)

After selecting the component click Ok or press ENTER

s109.JPG

Fig. (109) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s110.JPG

Fig. (110) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s111.JPG

Fig. (111) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s112.JPG

Fig. (112) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Set Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Set Field Value)

                Note : Stop typing when you see the required component is selected

s113.JPG

Fig. (113) Component Browser Select the component (ADO Set Field Value)

After selecting the component click Ok or press ENTER

s114.JPG

Fig. (114) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s115.JPG

Fig. (115) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Set Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Set Field Value)

                Note : Stop typing when you see the required component is selected

s116.JPG

Fig. (116) Component Browser Select the component (ADO Set Field Value)

After selecting the component click Ok or press ENTER

s117.JPG

Fig. (117) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s118.JPG

Fig. (118) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Set Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Set Field Value)

                Note : Stop typing when you see the required component is selected

s119.JPG

Fig. (119) Component Browser Select the component (ADO Set Field Value)

After selecting the component click Ok or press ENTER

s120.JPG

Fig. (120) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s121.JPG

Fig. (121) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Set Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Set Field Value)

                Note : Stop typing when you see the required component is selected

s122.JPG

Fig. (122) Component Browser Select the component (ADO Set Field Value)

After selecting the component click Ok or press ENTER

s123.JPG

Fig. (123) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s124.JPG

Fig. (124) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Update Record)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Update Record)

                Note : Stop typing when you see the required component is selected

s125.JPG

Fig. (125) Component Browser Select the component (ADO Update Record)

After selecting the component click Ok or press ENTER

s126.JPG

Fig. (126) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s127.JPG

Fig. (127) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Close RecordSet)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Close RecordSet)

                Note : Stop typing when you see the required component is selected

s128.JPG

Fig. (128) Component Browser Select the component (ADO Close RecordSet)

After selecting the component click Ok or press ENTER

s129.JPG

Fig. (129) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s130.JPG

Fig. (130) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Connection)

                3 - Select the component (ADO Close Connection)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Close Connection)

                Note : Stop typing when you see the required component is selected

s131.JPG

Fig. (131) Component Browser Select the component (ADO Close Connection)

After selecting the component click Ok or press ENTER

s132.JPG

Fig. (132) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s133.JPG

Fig. (133) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (GUI Application)

                3 - Select the component (Show Message)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Show Message)

                Note : Stop typing when you see the required component is selected

s134.JPG

Fig. (134) Component Browser Select the component (Show Message)

After selecting the component click Ok or press ENTER

s135.JPG

Fig. (135) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s136.JPG

Fig. (136) Goal Desginer - Steps Tree

Select the step (The First Step)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Structure Programming)

                3 - Select the component (Define Procedure)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Define Procedure)

                Note : Stop typing when you see the required component is selected

s137.JPG

Fig. (137) Component Browser Select the component (Define Procedure)

After selecting the component click Ok or press ENTER

s138.JPG

Fig. (138) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s139.JPG

Fig. (139) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Connection)

                3 - Select the component (ADO New Connection)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO New Connection)

                Note : Stop typing when you see the required component is selected

s140.JPG

Fig. (140) Component Browser Select the component (ADO New Connection)

After selecting the component click Ok or press ENTER

s141.JPG

Fig. (141) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s142.JPG

Fig. (142) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Connection)

                3 - Select the component (ADO Open Connection)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Open Connection)

                Note : Stop typing when you see the required component is selected

s143.JPG

Fig. (143) Component Browser Select the component (ADO Open Connection)

After selecting the component click Ok or press ENTER

s144.JPG

Fig. (144) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s145.JPG

Fig. (145) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO New RecordSet)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO New RecordSet)

                Note : Stop typing when you see the required component is selected

s146.JPG

Fig. (146) Component Browser Select the component (ADO New RecordSet)

After selecting the component click Ok or press ENTER

s147.JPG

Fig. (147) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s148.JPG

Fig. (148) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Open RecordSet)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Open RecordSet)

                Note : Stop typing when you see the required component is selected

s149.JPG

Fig. (149) Component Browser Select the component (ADO Open RecordSet)

After selecting the component click Ok or press ENTER

s150.JPG

Fig. (150) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s151.JPG

Fig. (151) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Get Records Count)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Get Records Count)

                Note : Stop typing when you see the required component is selected

s152.JPG

Fig. (152) Component Browser Select the component (ADO Get Records Count)

After selecting the component click Ok or press ENTER

s153.JPG

Fig. (153) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s154.JPG

Fig. (154) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Grid Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Grid Class)

                Note : Stop typing when you see the required component is selected

s155.JPG

Fig. (155) Component Browser Select the component (Grid Class)

After selecting the component click Ok or press ENTER

s156.JPG

Fig. (156) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s157.JPG

Fig. (157) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s158.JPG

Fig. (158) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s159.JPG

Fig. (159) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Control Structure)

                3 - Select the component (For Loop)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (For Loop)

                Note : Stop typing when you see the required component is selected

s160.JPG

Fig. (160) Component Browser Select the component (For Loop)

After selecting the component click Ok or press ENTER

s161.JPG

Fig. (161) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s162.JPG

Fig. (162) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Get Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Get Field Value)

                Note : Stop typing when you see the required component is selected

s163.JPG

Fig. (163) Component Browser Select the component (ADO Get Field Value)

After selecting the component click Ok or press ENTER

s164.JPG

Fig. (164) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s165.JPG

Fig. (165) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Get Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Get Field Value)

                Note : Stop typing when you see the required component is selected

s166.JPG

Fig. (166) Component Browser Select the component (ADO Get Field Value)

After selecting the component click Ok or press ENTER

s167.JPG

Fig. (167) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s168.JPG

Fig. (168) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Get Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Get Field Value)

                Note : Stop typing when you see the required component is selected

s169.JPG

Fig. (169) Component Browser Select the component (ADO Get Field Value)

After selecting the component click Ok or press ENTER

s170.JPG

Fig. (170) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s171.JPG

Fig. (171) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Get Field Value)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Get Field Value)

                Note : Stop typing when you see the required component is selected

s172.JPG

Fig. (172) Component Browser Select the component (ADO Get Field Value)

After selecting the component click Ok or press ENTER

s173.JPG

Fig. (173) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s174.JPG

Fig. (174) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Classes)

                3 - Select the component (Grid Class)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Grid Class)

                Note : Stop typing when you see the required component is selected

s175.JPG

Fig. (175) Component Browser Select the component (Grid Class)

After selecting the component click Ok or press ENTER

s176.JPG

Fig. (176) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s177.JPG

Fig. (177) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s178.JPG

Fig. (178) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s179.JPG

Fig. (179) Goal Desginer - Steps Tree

Select the step (Start Here)

We will start now new interaction process to generate new steps to our steps tree.

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO Goto Next Record)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (ADO Goto Next Record)

                Note : Stop typing when you see the required component is selected

s180.JPG

Fig. (180) Component Browser Select the component (ADO Goto Next Record)

After selecting the component click Ok or press ENTER

s181.JPG

Fig. (181) Interaction page - Set the properties and enter the required data as in the image above

Afer entering data , Click OK or press CTRL+W

s182.JPG

Fig. (182) Goal Desginer - Final Steps Tree

3 - Final Steps Tree

The First Step

                Define New Window ( win1 ) , Title : "patient database"

                                Window Events

                                Window Properties

                                Window Controls

                                                Define New Image ( image2 ) , Image : "HOSPITAL1.JPG"

                                                                Events

                                                                Properties

                                                Define Label ( lbl1 ) , Caption : "phone"

                                                                Label Events

                                                                Label Properties

                                                Define Label ( lbl2 ) , Caption : "patient name"

                                                                Label Events

                                                                Label Properties

                                                Define Label ( lbl3 ) , Caption : "address"

                                                                Label Events

                                                                Label Properties

                                                Define TextBox ( text1 )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                                Define TextBox ( text2 )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                                Define TextBox ( text3 )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                                Define New Button ( btn1 ) , Caption : "save record"

                                                                Button Events

                                                                                Event: ON CLICK : Action saverec()

                                                                Button Properties

                                                Define New Button ( btn2 ) , Caption : "Close"

                                                                Button Events

                                                                                Event: ON CLICK : Action myClose()

                                                                Button Properties

                                                Define New Grid ( Grid1 ) , HEADERS : {"Patient name","address","phone","Gender"}

                                                                Events

                                                                Properties

                                                Define New Button ( btn3 ) , Caption : "show Records"

                                                                Button Events

                                                                                Event: ON CLICK : Action showrec()

                                                                Button Properties

                                                Define Label ( lbl4 ) , Caption : "Gender"

                                                                Label Events

                                                                Label Properties

                                                Define TextBox ( text4 )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                End Of Window

                                Activate window

                Define Procedure myClose

                                Start Here

                                                win1.Release ( )

                                End of Procedure

                Define Procedure saverec

                                Start Here

                                                oCon = Create New ADODB Connection

                                                Open ADODB Connection oCon , Connection String : 'Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="dsn=MS Access Database;uid=";Initial Catalog=data.mdb'

                                                oRS = Create New ADODB RecordSet Object

                                                Open Recordset oRS , Connection oCon , CursorType 1 , SQL Statement "Select * from patient"

                                                ADODB RecordSet oRS - Add New Record

                                                oname = win1.text1.Value

                                                oaddress = win1.text2.Value

                                                ophone = win1.text3.Value

                                                ogender = win1.text4.Value

                                                ADODB RecordSet (oRS) Set Field ("patient name") Value To (oname)

                                                ADODB RecordSet (oRS) Set Field ("address") Value To (oaddress)

                                                ADODB RecordSet (oRS) Set Field ("phone") Value To (ophone)

                                                ADODB RecordSet (oRS) Set Field ("Gender") Value To (ogender)

                                                ADODB RecordSet oRS - Update Record

                                                Close ADODB RecordSet oRS

                                                Close ADODB Connection oCon

                                                Show Message " Done " Title "ok" Type: Message Box

                                End of Procedure

                Define Procedure showrec

                                Start Here

                                                oCon = Create New ADODB Connection

                                                Open ADODB Connection oCon , Connection String : 'Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="dsn=MS Access Database;uid=";Initial Catalog=data.mdb'

                                                oRS = Create New ADODB RecordSet Object

                                                Open Recordset oRS , Connection oCon , CursorType 1 , SQL Statement "Select * from patient"

                                                mymax := ADODB RecordSet (oRS) , Get Records Count

                                                win1.grid1.DeleteAllItems ( )

                                                FOR LOOP ( From x = 1 To mymax Step 1)

                                                                Start Here

                                                                                oname = ADODB RecordSet (oRS) Get Field ("patient name") Value

                                                                                oaddress = ADODB RecordSet (oRS) Get Field ("address") Value

                                                                                ophone = ADODB RecordSet (oRS) Get Field ("phone") Value

                                                                                ogender = ADODB RecordSet (oRS) Get Field ("gender") Value

                                                                                win1.grid1.AddItem ( {oname,oaddress,ophone,ogender} )

                                                                                ADODB RecordSet oRS - Goto Next Record

                                                                End of For Loop

                                End of Procedure

4 - Application during the runtime

runtime1.JPG

Fig. (183) Application during the runtime