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 create simple ADO application.

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 (Set AutoAdjust On)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Set AutoAdjust On)

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

s2.JPG

Fig. (2) Component Browser Select the component (Set AutoAdjust On)

After selecting the component click Ok or press ENTER

s3.JPG

Fig. (3) 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

s4.JPG

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

After selecting the component click Ok or press ENTER

s5.JPG

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

s6.JPG

Fig. (6) Form Designer

s7.JPG

Fig. (7) 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 (EditBox)

The fast way (Using Keyboard shortcuts):

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

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

s8.JPG

Fig. (8) Component Browser Select the component (EditBox)

After selecting the component click Ok or press ENTER

s9.JPG

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

s10.JPG

Fig. (10) Form Designer

s11.JPG

Fig. (11) 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

s12.JPG

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

After selecting the component click Ok or press ENTER

s13.JPG

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

s14.JPG

Fig. (14) Form Designer

s15.JPG

Fig. (15) 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

s16.JPG

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

After selecting the component click Ok or press ENTER

s17.JPG

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

s18.JPG

Fig. (18) 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

s19.JPG

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

After selecting the component click Ok or press ENTER

s20.JPG

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

s21.JPG

Fig. (21) Form Designer

s22.JPG

Fig. (22) 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

s23.JPG

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

After selecting the component click Ok or press ENTER

s24.JPG

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

s25.JPG

Fig. (25) Goal Desginer - Steps Tree

Select the step (Procedures)

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

s26.JPG

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

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

s28.JPG

Fig. (28) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s29.JPG

Fig. (29) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s30.JPG

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

s31.JPG

Fig. (31) 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

s32.JPG

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

After selecting the component click Ok or press ENTER

s33.JPG

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

s34.JPG

Fig. (34) 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

s35.JPG

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

After selecting the component click Ok or press ENTER

s36.JPG

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

s37.JPG

Fig. (37) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s38.JPG

Fig. (38) Component Browser Select the component (Print Text To Editbox)

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

s40.JPG

Fig. (40) 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

s41.JPG

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

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

s43.JPG

Fig. (43) 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

s44.JPG

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

After selecting the component click Ok or press ENTER

s45.JPG

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

s46.JPG

Fig. (46) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s47.JPG

Fig. (47) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s48.JPG

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

s49.JPG

Fig. (49) 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

s50.JPG

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

After selecting the component click Ok or press ENTER

s51.JPG

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

s52.JPG

Fig. (52) 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

s53.JPG

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

After selecting the component click Ok or press ENTER

s54.JPG

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

s55.JPG

Fig. (55) 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

s56.JPG

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

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

s58.JPG

Fig. (58) 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

s59.JPG

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

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

s61.JPG

Fig. (61) 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

s62.JPG

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

After selecting the component click Ok or press ENTER

s63.JPG

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

s64.JPG

Fig. (64) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s65.JPG

Fig. (65) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s66.JPG

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

s67.JPG

Fig. (67) 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

s68.JPG

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

After selecting the component click Ok or press ENTER

s69.JPG

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

s70.JPG

Fig. (70) 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

s71.JPG

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

After selecting the component click Ok or press ENTER

s72.JPG

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

s73.JPG

Fig. (73) Goal Desginer - Steps Tree

Select the step (Procedures)

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

s74.JPG

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

After selecting the component click Ok or press ENTER

s75.JPG

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

s76.JPG

Fig. (76) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s77.JPG

Fig. (77) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s78.JPG

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

s79.JPG

Fig. (79) 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

s80.JPG

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

After selecting the component click Ok or press ENTER

s81.JPG

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

s82.JPG

Fig. (82) 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

s83.JPG

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

After selecting the component click Ok or press ENTER

s84.JPG

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

s85.JPG

Fig. (85) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s86.JPG

Fig. (86) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s87.JPG

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

s88.JPG

Fig. (88) 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

s89.JPG

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

After selecting the component click Ok or press ENTER

s90.JPG

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

s91.JPG

Fig. (91) 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

s92.JPG

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

After selecting the component click Ok or press ENTER

s93.JPG

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

s94.JPG

Fig. (94) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s95.JPG

Fig. (95) Component Browser Select the component (Print Text To Editbox)

After selecting the component click Ok or press ENTER

s96.JPG

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

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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s98.JPG

Fig. (98) Component Browser Select the component (Print Text To Editbox)

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

s100.JPG

Fig. (100) 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

s101.JPG

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

After selecting the component click Ok or press ENTER

s102.JPG

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

s103.JPG

Fig. (103) 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 (IF Statement)

The fast way (Using Keyboard shortcuts):

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

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

s104.JPG

Fig. (104) Component Browser Select the component (IF Statement)

After selecting the component click Ok or press ENTER

s105.JPG

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

s106.JPG

Fig. (106) 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 (Structure Programming)

                3 - Select the component (Return Value)

The fast way (Using Keyboard shortcuts):

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

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

s107.JPG

Fig. (107) Component Browser Select the component (Return Value)

After selecting the component click Ok or press ENTER

s108.JPG

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

s109.JPG

Fig. (109) 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 First Record)

The fast way (Using Keyboard shortcuts):

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

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

s110.JPG

Fig. (110) Component Browser Select the component (ADO Goto First Record)

After selecting the component click Ok or press ENTER

s111.JPG

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

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 (HarbourPWCT)

                3 - Select the component ()

The fast way (Using Keyboard shortcuts):

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

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

s113.JPG

Fig. (113) Component Browser Select the component ()

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

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 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

s116.JPG

Fig. (116) Component Browser Select the component (ADO Get 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

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 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

s119.JPG

Fig. (119) Component Browser Select the component (ADO Get 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

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 (Variables)

                3 - Select the component (Numeric To String)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Numeric To String)

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

s122.JPG

Fig. (122) Component Browser Select the component (Numeric To String)

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

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 (Variables)

                3 - Select the component (Numeric To String)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Numeric To String)

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

s125.JPG

Fig. (125) Component Browser Select the component (Numeric To String)

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

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 (Variables)

                3 - Select the component (Assignment)

The fast way (Using Keyboard shortcuts):

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

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

s128.JPG

Fig. (128) Component Browser Select the component (Assignment)

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

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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s131.JPG

Fig. (131) Component Browser Select the component (Print Text To Editbox)

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

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 (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

s134.JPG

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

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

s136.JPG

Fig. (136) 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 (Print Text)

                3 - Select the component (Print Text To Editbox)

The fast way (Using Keyboard shortcuts):

                1 - Get the component using its name by typing (Print Text To Editbox)

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

s137.JPG

Fig. (137) Component Browser Select the component (Print Text To Editbox)

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

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 (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

s140.JPG

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

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

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 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

s143.JPG

Fig. (143) Component Browser Select the component (ADO Close 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

s145.JPG

Fig. (145) Goal Desginer - Final Steps Tree

3 - Final Steps Tree

The First Step

                Set AutoAdjust ON

                Define New Window ( win1 ) , Title : "ADODB Sample"

                                Window Events

                                Window Properties

                                Window Controls

                                                Define New Editbox ( edit1 )

                                                                Editbox Events

                                                                Editbox Properties

                                                Define New Button ( btn1 ) , Caption : "Add 10 Records"

                                                                Button Events

                                                                                Event: ON CLICK : Action mywork()

                                                                Button Properties

                                                Define New Button ( btn2 ) , Caption : "Show Records"

                                                                Button Events

                                                                                Event: ON CLICK : Action mywork2()

                                                                Button Properties

                                End Of Window

                                Activate window

Procedures

                Define Procedure mywork

                                Start Here

                                                Print text ("Open Database Test.MDB ") to Editbox (Edit1) of Window (Win1)

                                                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=test.mdb'

                                                Print text ("Open Table MainTable ") to Editbox (Edit1) of Window (Win1)

                                                oRS = Create New ADODB RecordSet Object

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

                                                Print text ("Add 10 Records ") to Editbox (Edit1) of Window (Win1)

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

                                                                Start Here

                                                                                ADODB RecordSet oRS - Add New Record

                                                                                ADODB RecordSet (oRS) Set Field ("number") Value To (x)

                                                                                ADODB RecordSet (oRS) Set Field ("sqare") Value To (x*x)

                                                                                ADODB RecordSet oRS - Update Record

                                                                End of For Loop

                                                Print text ("Close RecordSet & Close Connection ") to Editbox (Edit1) of Window (Win1)

                                                Close ADODB RecordSet oRS

                                                Close ADODB Connection oCon

                                End of Procedure

                Define Procedure mywork2

                                Start Here

                                                Print text ("Open Database Test.MDB ") to Editbox (Edit1) of Window (Win1)

                                                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=test.mdb'

                                                Print text ("Open Table MainTable ") to Editbox (Edit1) of Window (Win1)

                                                oRS = Create New ADODB RecordSet Object

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

                                                Print text ("Show Records ") to Editbox (Edit1) of Window (Win1)

                                                Print text (" Number                                Sqare") to Editbox (Edit1) of Window (Win1)

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

                                                IF ( nOutput = 0 )

                                                                Start Here

                                                                                Return 0

                                                                END OF IF STATEMENT

                                                ADODB RecordSet oRS - Goto First Record

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

                                                                Start Here

                                                                                v1 = ADODB RecordSet (oRS) Get Field ("Number") Value

                                                                                v2 = ADODB RecordSet (oRS) Get Field ("Sqare") Value

                                                                                v1 = CONVERT v1 TO STRING

                                                                                v2 = CONVERT v2 TO STRING

                                                                                v3 = v1 + "                                " + v2

                                                                                Print text (v3) to Editbox (Edit1) of Window (Win1)

                                                                                ADODB RecordSet oRS - Goto Next Record

                                                                End of For Loop

                                                Print text ("Close RecordSet & Close Connection ") to Editbox (Edit1) of Window (Win1)

                                                Close ADODB RecordSet oRS

                                                Close ADODB Connection oCon

                                End of Procedure

4 - Application during the runtime

runtime1.JPG

Fig. (146) Application during the runtime

runtime2.JPG

Fig. (147) Application during the runtime