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