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

2006-2019, 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

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

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

After selecting the component click Ok or press ENTER

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

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

After selecting the component click Ok or press ENTER

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

Fig. (6) Form Designer

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

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

After selecting the component click Ok or press ENTER

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

Fig. (10) Form Designer

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

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

After selecting the component click Ok or press ENTER

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

Fig. (14) Form Designer

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

Fig. (21) Form Designer

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

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

After selecting the component click Ok or press ENTER

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

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

Fig. (146) Application during the runtime

Fig. (147) Application during the runtime