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

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

_____________________________________________________________________________________

Table of contents

1 - Introduction

2 - Implementation steps

3 - Final Steps Tree

4 - Application during the runtime

1 - Introduction

In this lesson we are going to learn 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