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 learn about using ADO and SQL (Part 1).

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

s4.JPG

Fig. (4) Form Designer

s5.JPG

Fig. (5) Goal Desginer - Steps Tree

Select the step (Window 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 (Windows)

                3 - Select the component (Window Events)

The fast way (Using Keyboard shortcuts):

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

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

s6.JPG

Fig. (6) Component Browser – Select the component (Window Events)

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

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

s10.JPG

Fig. (10) Component Browser – Select the component (TextBox)

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

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

s14.JPG

Fig. (14) Component Browser – Select the component (TextBox)

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

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

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

s22.JPG

Fig. (22) Component Browser – Select the component (Label)

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

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

s26.JPG

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

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) Form Designer

s29.JPG

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

s30.JPG

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

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

s32.JPG

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

s33.JPG

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

After selecting the component click Ok or press ENTER

s34.JPG

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

s35.JPG

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

s36.JPG

Fig. (36) Component Browser – Select the component (Window Class)

After selecting the component click Ok or press ENTER

s37.JPG

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

s38.JPG

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

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

s41.JPG

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

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

s44.JPG

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

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

s47.JPG

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

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

s50.JPG

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

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

s53.JPG

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

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

s56.JPG

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

s59.JPG

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

s62.JPG

Fig. (62) Component Browser – Select the component (Textbox Class)

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) Interaction page - Set the properties and enter the required data as in the image above

s65.JPG

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

s66.JPG

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

s67.JPG

Fig. (67) Component Browser – Select the component (Textbox Class)

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

s69.JPG

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

s70.JPG

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

s71.JPG

Fig. (71) Goal Desginer - Final Steps Tree

3 - Final Steps Tree

The First Step

                Define New Window ( win1 ) , Title : "Contacts - by Ahmed Omar"

                                Window Events

                                                Event: ON INIT : Action openDB()

                                Window Properties

                                Window Controls

                                                Define TextBox ( txtname )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                                Define TextBox ( txtphone )

                                                                TextBox EVENTS

                                                                TextBox Properties

                                                Define Label ( lbl1 ) , Caption : "Name :"

                                                                Label Events

                                                                Label Properties

                                                Define Label ( lbl2 ) , Caption : "Phone :"

                                                                Label Events

                                                                Label Properties

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

                                                                Button Events

                                                                                Event: ON CLICK : Action close()

                                                                Button Properties

                                End Of Window

                                Activate window

                Define Procedure close()

                                Start Here

                                                win1.Release ( )

                                End of Procedure

                Define Procedure openDB

                                Start Here

                                                conn = Create New ADODB Connection

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

                                                oRS = Create New ADODB RecordSet Object

                                                Open Recordset oRS , Connection conn , CursorType 1 , SQL Statement "Select * from contacts"

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

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

                                                win1.txtname.Value := name

                                                win1.txtphone.Value := phone

                                End of Procedure

4 - Application during the runtime

runtime1.JPG

Fig. (72) Application during the runtime