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

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

_____________________________________________________________________________________

Table of contents

1 - Introduction

2 - Implementation steps

3 - Final Steps Tree

4 - Application during the runtime

1 - Introduction

In this lesson we are going to learn how to search in our table.

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

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

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Image)

The fast way (Using Keyboard shortcuts):

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

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

s6.JPG

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

After selecting the component click Ok or press ENTER

s7.JPG

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

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

s14.JPG

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

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

s18.JPG

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

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

The fast way (Using Keyboard shortcuts):

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

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

s21.JPG

Fig. (21) Component Browser Select the component (ListBox)

After selecting the component click Ok or press ENTER

s22.JPG

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

s23.JPG

Fig. (23) Form Designer

s24.JPG

Fig. (24) Goal Desginer - Steps Tree

Select the step (Window Controls)

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

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (Controls)

                3 - Select the component (Image)

The fast way (Using Keyboard shortcuts):

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

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

s25.JPG

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

After selecting the component click Ok or press ENTER

s26.JPG

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

s27.JPG

Fig. (27) Form Designer

s28.JPG

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

s29.JPG

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

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

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

s36.JPG

Fig. (36) Component Browser Select the component (Textbox 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 (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

s41.JPG

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

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

s44.JPG

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

s47.JPG

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

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

s50.JPG

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

s53.JPG

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

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

                3 - Select the component (Listbox Class)

The fast way (Using Keyboard shortcuts):

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

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

s56.JPG

Fig. (56) Component Browser Select the component (Listbox Class)

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

s59.JPG

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

s60.JPG

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

s61.JPG

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

After selecting the component click Ok or press ENTER

s62.JPG

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

s63.JPG

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

s64.JPG

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

After selecting the component click Ok or press ENTER

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

s67.JPG

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

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

s70.JPG

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

After selecting the component click Ok or press ENTER

s71.JPG

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

s72.JPG

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

s73.JPG

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

After selecting the component click Ok or press ENTER

s74.JPG

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

s75.JPG

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

s76.JPG

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

After selecting the component click Ok or press ENTER

s77.JPG

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

s78.JPG

Fig. (78) 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 (Listbox Class)

The fast way (Using Keyboard shortcuts):

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

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

s79.JPG

Fig. (79) Component Browser Select the component (Listbox Class)

After selecting the component click Ok or press ENTER

s80.JPG

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

s81.JPG

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

s82.JPG

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

s83.JPG

Fig. (83) Goal Desginer - Steps Tree

Select the step (Start Here)

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

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (RecordSet)

                3 - Select the component (ADO 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

s84.JPG

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

After selecting the component click Ok or press ENTER

s85.JPG

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

s86.JPG

Fig. (86) Goal Desginer - Steps Tree

Select the step (Start Here)

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

The slow way (Using Mouse):

                1 - Click Interact to open the components browser

                2 - Select the domain (GUI Application)

                3 - Select the component (Show Message)

The fast way (Using Keyboard shortcuts):

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

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

s87.JPG

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

After selecting the component click Ok or press ENTER

s88.JPG

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

s89.JPG

Fig. (89) Goal Desginer - Final Steps Tree

3 - Final Steps Tree

The First Step

                Define New Window ( win1 ) , Title : "Student Search"

                                Window Events

                                Window Properties

                                Window Controls

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

                                                                Events

                                                                Properties

                                                Define TextBox ( text1 )

                                                                TextBox EVENTS

                                                                TextBox Properties

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

                                                                Button Events

                                                                                Event: ON CLICK : Action search()

                                                                Button Properties

                                                Define New ListBox ( list1 )

                                                                ListBox Event

                                                                ListBox Properties

                                                Define New Image ( image1 ) , Image : "A_GIRL_CARRYING_A_STACK_OF_BOOKS_0521-1005-0821-5935_SMU.JPG"

                                                                Events

                                                                Properties

                                                Define Label ( lbl1 ) , Caption : "Name"

                                                                Label Events

                                                                Label Properties

                                End Of Window

                                Activate window

                Define Procedure search

                                Start Here

                                                oName = win1.text1.Value

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

                                                oRS = Create New ADODB RecordSet Object

                                                Open Recordset oRS , Connection oCon , CursorType 1 , SQL Statement "Select * from students where name like '"+ oname+ "%'"

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

                                                win1.list1.DeleteAllItems ( )

                                                IF ( mymax >0 )

                                                                Start Here

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

                                                                                                Start Here

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

                                                                                                                onan = ADODB RecordSet (oRS) Get Field ("nationalty") Value

                                                                                                                ograde = ADODB RecordSet (oRS) Get Field ("grade") Value

                                                                                                                onum = ADODB RecordSet (oRS) Get Field ("number") Value

                                                                                                                win1.list1.AddItem ( oname+"-"+onan+"-"+ograde+"-"+onum+"-" )

                                                                                                                ADODB RecordSet oRS - Goto Next Record

                                                                                                End of For Loop

                                                                ELSE

                                                                                Start Here

                                                                                                Show Message "Record not found" Title "sorry" Type: Message Box

                                                                END OF IF STATEMENT

                                End of Procedure

4 - Application during the runtime

runtime1.JPG

Fig. (90) Application during the runtime