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 2). 2 - Implementation Steps Fig. (1) Goal Desginer - Steps Tree Select the step (The First Step) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Windows) 3 - Select the component (Define New Window) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Define New Window) Note : Stop typing when you see the required component is selected Fig. (2) Component Browser – Select the component (Define New Window) After selecting the component click Ok or press ENTER Fig. (3) Interaction page - Set the properties and enter the required data as in the image above Fig. (4) Form Designer 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 Fig. (6) Component Browser – Select the component (Window Events) After selecting the component click Ok or press ENTER Fig. (7) Interaction page - Set the properties and enter the required data as in the image above Fig. (8) Form Designer 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 Fig. (10) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (11) Interaction page - Set the properties and enter the required data as in the image above Fig. (12) Form Designer 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 Fig. (14) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (15) Interaction page - Set the properties and enter the required data as in the image above Fig. (16) Form Designer 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 Fig. (18) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (19) Interaction page - Set the properties and enter the required data as in the image above Fig. (20) Form Designer 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 Fig. (22) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (23) Interaction page - Set the properties and enter the required data as in the image above Fig. (24) Form Designer 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 Fig. (26) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (27) Interaction page - Set the properties and enter the required data as in the image above Fig. (28) Form Designer 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 Fig. (30) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (31) Interaction page - Set the properties and enter the required data as in the image above Fig. (32) Goal Desginer - Steps Tree Select the step (Window Controls) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Controls) 3 - Select the component (Button) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button) Note : Stop typing when you see the required component is selected Fig. (33) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (34) Interaction page - Set the properties and enter the required data as in the image above Fig. (35) Form Designer Fig. (36) Goal Desginer - Steps Tree Select the step (Button Events) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Events) 3 - Select the component (Button Events) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Events) Note : Stop typing when you see the required component is selected Fig. (37) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (38) Interaction page - Set the properties and enter the required data as in the image above Fig. (39) 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 Fig. (40) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (41) Interaction page - Set the properties and enter the required data as in the image above Fig. (42) Form Designer Fig. (43) 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 Fig. (44) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (45) Interaction page - Set the properties and enter the required data as in the image above Fig. (46) Form Designer Fig. (47) 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 Fig. (48) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (49) Interaction page - Set the properties and enter the required data as in the image above Fig. (50) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Structure Programming) 3 - Select the component (Call Procedure) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Call Procedure) Note : Stop typing when you see the required component is selected Fig. (51) Component Browser – Select the component (Call Procedure) After selecting the component click Ok or press ENTER Fig. (52) Interaction page - Set the properties and enter the required data as in the image above Fig. (53) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO Open RecordSet) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Open RecordSet) Note : Stop typing when you see the required component is selected Fig. (54) Component Browser – Select the component (ADO Open RecordSet) After selecting the component click Ok or press ENTER Fig. (55) Interaction page - Set the properties and enter the required data as in the image above Fig. (56) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO Get Field Value) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Get Field Value) Note : Stop typing when you see the required component is selected Fig. (57) Component Browser – Select the component (ADO Get Field Value) After selecting the component click Ok or press ENTER Fig. (58) Interaction page - Set the properties and enter the required data as in the image above Fig. (59) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO Get Field Value) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Get Field Value) Note : Stop typing when you see the required component is selected Fig. (60) Component Browser – Select the component (ADO Get Field Value) After selecting the component click Ok or press ENTER Fig. (61) Interaction page - Set the properties and enter the required data as in the image above Fig. (62) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO Get Field Value) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Get Field Value) Note : Stop typing when you see the required component is selected Fig. (63) Component Browser – Select the component (ADO Get Field Value) After selecting the component click Ok or press ENTER Fig. (64) Interaction page - Set the properties and enter the required data as in the image above Fig. (65) 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 Fig. (66) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (67) Interaction page - Set the properties and enter the required data as in the image above Fig. (68) Interaction page - Set the properties and enter the required data as in the image above Fig. (69) Interaction page - Set the properties and enter the required data as in the image above Fig. (70) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (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 Fig. (71) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (72) Interaction page - Set the properties and enter the required data as in the image above Fig. (73) Interaction page - Set the properties and enter the required data as in the image above Fig. (74) Interaction page - Set the properties and enter the required data as in the image above 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 (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 Fig. (76) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (77) Interaction page - Set the properties and enter the required data as in the image above Fig. (78) Interaction page - Set the properties and enter the required data as in the image above Fig. (79) Interaction page - Set the properties and enter the required data as in the image above Fig. (80) 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 Fig. (81) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (82) Interaction page - Set the properties and enter the required data as in the image above 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 (Windows) 3 - Select the component (Define New Window) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Define New Window) Note : Stop typing when you see the required component is selected Fig. (84) Component Browser – Select the component (Define New Window) After selecting the component click Ok or press ENTER Fig. (85) Interaction page - Set the properties and enter the required data as in the image above Fig. (86) Form Designer Fig. (87) 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 Fig. (88) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (89) Interaction page - Set the properties and enter the required data as in the image above Fig. (90) Form Designer Fig. (91) 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 Fig. (92) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (93) Interaction page - Set the properties and enter the required data as in the image above Fig. (94) Form Designer Fig. (95) 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 Fig. (96) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (97) Interaction page - Set the properties and enter the required data as in the image above Fig. (98) Form Designer Fig. (99) 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 Fig. (100) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (101) Interaction page - Set the properties and enter the required data as in the image above Fig. (102) Form Designer Fig. (103) 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 Fig. (104) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (105) Interaction page - Set the properties and enter the required data as in the image above Fig. (106) Form Designer Fig. (107) 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 Fig. (108) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (109) Interaction page - Set the properties and enter the required data as in the image above Fig. (110) Form Designer Fig. (111) 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 Fig. (112) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (113) Interaction page - Set the properties and enter the required data as in the image above Fig. (114) Form Designer Fig. (115) Goal Desginer - Steps Tree Select the step (Window Controls) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Controls) 3 - Select the component (Button) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button) Note : Stop typing when you see the required component is selected Fig. (116) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (117) Interaction page - Set the properties and enter the required data as in the image above Fig. (118) Form Designer Fig. (119) Goal Desginer - Steps Tree Select the step (Button Events) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Events) 3 - Select the component (Button Events) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Events) Note : Stop typing when you see the required component is selected Fig. (120) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (121) Interaction page - Set the properties and enter the required data as in the image above Fig. (122) Goal Desginer - Steps Tree Select the step (Window Controls) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Controls) 3 - Select the component (Button) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button) Note : Stop typing when you see the required component is selected Fig. (123) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (124) Interaction page - Set the properties and enter the required data as in the image above Fig. (125) Form Designer Fig. (126) Goal Desginer - Steps Tree Select the step (Button Events) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Events) 3 - Select the component (Button Events) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Events) Note : Stop typing when you see the required component is selected Fig. (127) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (128) Interaction page - Set the properties and enter the required data as in the image above Fig. (129) 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 Fig. (130) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (131) Interaction page - Set the properties and enter the required data as in the image above Fig. (132) 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 Fig. (133) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (134) Interaction page - Set the properties and enter the required data as in the image above Fig. (135) Interaction page - Set the properties and enter the required data as in the image above Fig. (136) Interaction page - Set the properties and enter the required data as in the image above Fig. (137) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Control Structure) 3 - Select the component (IF Statement) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (IF Statement) Note : Stop typing when you see the required component is selected Fig. (138) Component Browser – Select the component (IF Statement) After selecting the component click Ok or press ENTER Fig. (139) Interaction page - Set the properties and enter the required data as in the image above Fig. (140) 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 Fig. (141) Component Browser – Select the component (Show Message) After selecting the component click Ok or press ENTER Fig. (142) Interaction page - Set the properties and enter the required data as in the image above Fig. (143) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Structure Programming) 3 - Select the component (Call Procedure) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Call Procedure) Note : Stop typing when you see the required component is selected Fig. (144) Component Browser – Select the component (Call Procedure) After selecting the component click Ok or press ENTER Fig. (145) Interaction page - Set the properties and enter the required data as in the image above Fig. (146) 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 Fig. (147) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (148) Interaction page - Set the properties and enter the required data as in the image above Fig. (149) Interaction page - Set the properties and enter the required data as in the image above Fig. (150) Interaction page - Set the properties and enter the required data as in the image above Fig. (151) 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 Fig. (152) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (153) Interaction page - Set the properties and enter the required data as in the image above Fig. (154) Interaction page - Set the properties and enter the required data as in the image above Fig. (155) Interaction page - Set the properties and enter the required data as in the image above Fig. (156) 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 Fig. (157) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (158) Interaction page - Set the properties and enter the required data as in the image above Fig. (159) Interaction page - Set the properties and enter the required data as in the image above Fig. (160) Interaction page - Set the properties and enter the required data as in the image above Fig. (161) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO Open RecordSet) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Open RecordSet) Note : Stop typing when you see the required component is selected Fig. (162) Component Browser – Select the component (ADO Open RecordSet) After selecting the component click Ok or press ENTER Fig. (163) Interaction page - Set the properties and enter the required data as in the image above Fig. (164) 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 Fig. (165) Component Browser – Select the component (Show Message) After selecting the component click Ok or press ENTER Fig. (166) Interaction page - Set the properties and enter the required data as in the image above Fig. (167) 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 Fig. (168) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (169) Interaction page - Set the properties and enter the required data as in the image above Fig. (170) Interaction page - Set the properties and enter the required data as in the image above Fig. (171) Interaction page - Set the properties and enter the required data as in the image above Fig. (172) 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 Fig. (173) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (174) Interaction page - Set the properties and enter the required data as in the image above Fig. (175) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Connection) 3 - Select the component (ADO New Connection) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO New Connection) Note : Stop typing when you see the required component is selected Fig. (176) Component Browser – Select the component (ADO New Connection) After selecting the component click Ok or press ENTER Fig. (177) Interaction page - Set the properties and enter the required data as in the image above Fig. (178) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (Connection) 3 - Select the component (ADO Open Connection) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO Open Connection) Note : Stop typing when you see the required component is selected Fig. (179) Component Browser – Select the component (ADO Open Connection) After selecting the component click Ok or press ENTER Fig. (180) Interaction page - Set the properties and enter the required data as in the image above Fig. (181) Goal Desginer - Steps Tree Select the step (Start Here) We will start now new interaction process to generate new steps to our steps tree. The slow way (Using Mouse): 1 - Click Interact to open the components browser 2 - Select the domain (RecordSet) 3 - Select the component (ADO New RecordSet) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (ADO New RecordSet) Note : Stop typing when you see the required component is selected Fig. (182) Component Browser – Select the component (ADO New RecordSet) After selecting the component click Ok or press ENTER Fig. (183) Interaction page - Set the properties and enter the required data as in the image above Fig. (184) 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 Fig. (185) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (186) Interaction page - Set the properties and enter the required data as in the image above Fig. (187) 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 Fig. (188) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (189) Interaction page - Set the properties and enter the required data as in the image above Fig. (190) Interaction page - Set the properties and enter the required data as in the image above Fig. (191) Interaction page - Set the properties and enter the required data as in the image above Fig. (192) 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 Fig. (193) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (194) Interaction page - Set the properties and enter the required data as in the image above Fig. (195) 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 Fig. (196) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (197) Interaction page - Set the properties and enter the required data as in the image above Fig. (198) Interaction page - Set the properties and enter the required data as in the image above Fig. (199) Interaction page - Set the properties and enter the required data as in the image above Fig. (200) Goal Desginer - Final Steps Tree 3 - Final Steps Tree The First Step Define New Window ( win1 ) , Title : "Contacts" 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 close1 Button Properties Define New Button ( btnInsert ) , Caption : "New Data" Button Events Event: ON CLICK : Action newData Button Properties Define Label ( lbl3 ) , Caption : "Address :" Label Events Label Properties Define TextBox ( txtAddress ) TextBox EVENTS TextBox Properties End Of Window Activate window Define Procedure openDB Start Here Call Procedure conn 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 address = ADODB RecordSet (oRS) Get Field ("address") Value win1.txtname.Value := name win1.txtphone.Value := phone win1.txtAddress.Value := address End of Procedure Define Procedure newData Start Here Define New Window ( win2 ) , Title : "Insert New data" Window Events Window Properties Window Controls Define TextBox ( txtname ) TextBox EVENTS TextBox Properties Define TextBox ( txtphone ) TextBox EVENTS TextBox Properties Define TextBox ( txtAddress ) TextBox EVENTS TextBox Properties Define Label ( lbl1 ) , Caption : "Name :" Label Events Label Properties Define Label ( lbl2 ) , Caption : "Phone :" Label Events Label Properties Define Label ( lbl3 ) , Caption : "Address :" Label Events Label Properties Define Label ( lbl4 ) , Caption : "Insert New Data" Label Events Label Properties Define New Button ( btnSave ) , Caption : "Save" Button Events Event: ON CLICK : Action insert() Button Properties Define New Button ( btnBack ) , Caption : "<<<" Button Events Event: ON CLICK : Action close2() Button Properties End Of Window Activate window End of Procedure Define Procedure insert Start Here name = win2.txtName.Value IF ( name=="" ) Start Here Show Message "You Should Type Name..." Title "Error Data" Type: Message Exclamation ELSE Start Here Call Procedure conn name = win2.txtName.Value phone = win2.txtPhone.Value address = win2.txtAddress.Value Open Recordset oRS , Connection conn , CursorType 1 , SQL Statement "insert into contacts values('"+ name +"','"+ phone +"','"+ address +"')" Show Message "Contact : "+ name + " Added Successfully" Title "Success" Type: Message Box win2.Release ( ) END OF IF STATEMENT End of Procedure Define Procedure conn 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 End of Procedure Define Procedure close1 Start Here win1.Release ( ) End of Procedure Define Procedure close2 Start Here win2.Release ( ) End of Procedure 4 - Application during the runtime Fig. (201) Application during the runtime Fig. (202) Application during the runtime
|