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 3). 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 (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. (48) Component Browser – Select the component (Button) 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) Form Designer Fig. (51) 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. (52) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (53) Interaction page - Set the properties and enter the required data as in the image above Fig. (54) 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. (55) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (56) Interaction page - Set the properties and enter the required data as in the image above Fig. (57) Form Designer Fig. (58) 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. (59) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (60) Interaction page - Set the properties and enter the required data as in the image above Fig. (61) 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. (62) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (63) Interaction page - Set the properties and enter the required data as in the image above Fig. (64) 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 (Button Class) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Class) Note : Stop typing when you see the required component is selected Fig. (65) Component Browser – Select the component (Button Class) After selecting the component click Ok or press ENTER Fig. (66) Interaction page - Set the properties and enter the required data as in the image above 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) 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. (70) Component Browser – Select the component (Call Procedure) After selecting the component click Ok or press ENTER Fig. (71) Interaction page - Set the properties and enter the required data as in the image above 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 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. (73) Component Browser – Select the component (ADO Open RecordSet) After selecting the component click Ok or press ENTER 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 (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. (76) Component Browser – Select the component (ADO Get Field Value) 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) 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. (79) Component Browser – Select the component (ADO Get Field Value) After selecting the component click Ok or press ENTER Fig. (80) Interaction page - Set the properties and enter the required data as in the image above Fig. (81) 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. (82) Component Browser – Select the component (ADO Get Field Value) After selecting the component click Ok or press ENTER Fig. (83) Interaction page - Set the properties and enter the required data as in the image above Fig. (84) 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. (85) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (86) Interaction page - Set the properties and enter the required data as in the image above Fig. (87) Interaction page - Set the properties and enter the required data as in the image above Fig. (88) Interaction page - Set the properties and enter the required data as in the image above Fig. (89) 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. (90) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (91) Interaction page - Set the properties and enter the required data as in the image above Fig. (92) Interaction page - Set the properties and enter the required data as in the image above Fig. (93) Interaction page - Set the properties and enter the required data as in the image above Fig. (94) 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. (95) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (96) Interaction page - Set the properties and enter the required data as in the image above Fig. (97) Interaction page - Set the properties and enter the required data as in the image above Fig. (98) Interaction page - Set the properties and enter the required data as in the image above Fig. (99) 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. (100) Component Browser – Select the component (Define Procedure) 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) 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. (103) Component Browser – Select the component (Define New Window) After selecting the component click Ok or press ENTER Fig. (104) Interaction page - Set the properties and enter the required data as in the image above Fig. (105) Form Designer Fig. (106) 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. (107) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (108) Interaction page - Set the properties and enter the required data as in the image above Fig. (109) Form Designer Fig. (110) 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. (111) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (112) Interaction page - Set the properties and enter the required data as in the image above Fig. (113) Form Designer Fig. (114) 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. (115) Component Browser – Select the component (TextBox) After selecting the component click Ok or press ENTER Fig. (116) Interaction page - Set the properties and enter the required data as in the image above Fig. (117) Form Designer Fig. (118) 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. (119) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (120) Interaction page - Set the properties and enter the required data as in the image above Fig. (121) Form Designer 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 (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. (123) Component Browser – Select the component (Label) 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 (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. (127) Component Browser – Select the component (Label) 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) Form Designer Fig. (130) 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. (131) Component Browser – Select the component (Label) After selecting the component click Ok or press ENTER Fig. (132) Interaction page - Set the properties and enter the required data as in the image above Fig. (133) Form Designer Fig. (134) 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. (135) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (136) Interaction page - Set the properties and enter the required data as in the image above Fig. (137) Form Designer Fig. (138) 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. (139) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (140) Interaction page - Set the properties and enter the required data as in the image above Fig. (141) 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. (142) Component Browser – Select the component (Button) After selecting the component click Ok or press ENTER Fig. (143) Interaction page - Set the properties and enter the required data as in the image above Fig. (144) Form Designer Fig. (145) 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. (146) Component Browser – Select the component (Button Events) After selecting the component click Ok or press ENTER Fig. (147) Interaction page - Set the properties and enter the required data as in the image above Fig. (148) 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. (149) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER 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 (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. (157) Component Browser – Select the component (IF Statement) 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) 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. (160) Component Browser – Select the component (Show Message) After selecting the component click Ok or press ENTER Fig. (161) Interaction page - Set the properties and enter the required data as in the image above Fig. (162) 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. (163) Component Browser – Select the component (Call Procedure) After selecting the component click Ok or press ENTER Fig. (164) Interaction page - Set the properties and enter the required data as in the image above Fig. (165) 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. (166) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (167) Interaction page - Set the properties and enter the required data as in the image above Fig. (168) Interaction page - Set the properties and enter the required data as in the image above Fig. (169) Interaction page - Set the properties and enter the required data as in the image above Fig. (170) 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. (171) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (172) Interaction page - Set the properties and enter the required data as in the image above Fig. (173) Interaction page - Set the properties and enter the required data as in the image above 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 (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. (176) Component Browser – Select the component (Textbox Class) 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) Interaction page - Set the properties and enter the required data as in the image above Fig. (179) Interaction page - Set the properties and enter the required data as in the image above Fig. (180) 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. (181) Component Browser – Select the component (ADO Open RecordSet) After selecting the component click Ok or press ENTER Fig. (182) Interaction page - Set the properties and enter the required data as in the image above Fig. (183) 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. (184) Component Browser – Select the component (Show Message) After selecting the component click Ok or press ENTER Fig. (185) Interaction page - Set the properties and enter the required data as in the image above Fig. (186) 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. (187) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (188) Interaction page - Set the properties and enter the required data as in the image above 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) 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. (192) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (193) Interaction page - Set the properties and enter the required data as in the image above Fig. (194) 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. (195) Component Browser – Select the component (ADO New Connection) After selecting the component click Ok or press ENTER Fig. (196) Interaction page - Set the properties and enter the required data as in the image above Fig. (197) 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. (198) Component Browser – Select the component (ADO Open Connection) After selecting the component click Ok or press ENTER Fig. (199) Interaction page - Set the properties and enter the required data as in the image above Fig. (200) 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. (201) Component Browser – Select the component (ADO New RecordSet) After selecting the component click Ok or press ENTER Fig. (202) Interaction page - Set the properties and enter the required data as in the image above Fig. (203) 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. (204) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (205) Interaction page - Set the properties and enter the required data as in the image above Fig. (206) 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. (207) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (208) Interaction page - Set the properties and enter the required data as in the image above Fig. (209) Interaction page - Set the properties and enter the required data as in the image above Fig. (210) Interaction page - Set the properties and enter the required data as in the image above Fig. (211) 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. (212) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (213) Interaction page - Set the properties and enter the required data as in the image above Fig. (214) 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. (215) Component Browser – Select the component (Window Class) After selecting the component click Ok or press ENTER Fig. (216) Interaction page - Set the properties and enter the required data as in the image above Fig. (217) Interaction page - Set the properties and enter the required data as in the image above Fig. (218) Interaction page - Set the properties and enter the required data as in the image above Fig. (219) 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. (220) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (221) Interaction page - Set the properties and enter the required data as in the image above Fig. (222) 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 (Button Class) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Class) Note : Stop typing when you see the required component is selected Fig. (223) Component Browser – Select the component (Button Class) After selecting the component click Ok or press ENTER Fig. (224) Interaction page - Set the properties and enter the required data as in the image above Fig. (225) Interaction page - Set the properties and enter the required data as in the image above Fig. (226) Interaction page - Set the properties and enter the required data as in the image above Fig. (227) 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 (Button Class) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Class) Note : Stop typing when you see the required component is selected Fig. (228) Component Browser – Select the component (Button Class) After selecting the component click Ok or press ENTER Fig. (229) Interaction page - Set the properties and enter the required data as in the image above Fig. (230) Interaction page - Set the properties and enter the required data as in the image above Fig. (231) Interaction page - Set the properties and enter the required data as in the image above Fig. (232) 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. (233) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (234) Interaction page - Set the properties and enter the required data as in the image above Fig. (235) Interaction page - Set the properties and enter the required data as in the image above Fig. (236) Interaction page - Set the properties and enter the required data as in the image above Fig. (237) 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. (238) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (239) Interaction page - Set the properties and enter the required data as in the image above Fig. (240) Interaction page - Set the properties and enter the required data as in the image above Fig. (241) Interaction page - Set the properties and enter the required data as in the image above Fig. (242) 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. (243) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (244) Interaction page - Set the properties and enter the required data as in the image above Fig. (245) Interaction page - Set the properties and enter the required data as in the image above Fig. (246) Interaction page - Set the properties and enter the required data as in the image above Fig. (247) 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. (248) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (249) Interaction page - Set the properties and enter the required data as in the image above Fig. (250) Interaction page - Set the properties and enter the required data as in the image above Fig. (251) Interaction page - Set the properties and enter the required data as in the image above Fig. (252) 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. (454) Component Browser – Select the component (Define Procedure) After selecting the component click Ok or press ENTER Fig. (254) Interaction page - Set the properties and enter the required data as in the image above Fig. (255) 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. (256) Component Browser – Select the component (Call Procedure) After selecting the component click Ok or press ENTER Fig. (257) Interaction page - Set the properties and enter the required data as in the image above Fig. (258) 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. (259) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (260) Interaction page - Set the properties and enter the required data as in the image above Fig. (261) Interaction page - Set the properties and enter the required data as in the image above Fig. (262) Interaction page - Set the properties and enter the required data as in the image above Fig. (263) 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. (264) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (265) Interaction page - Set the properties and enter the required data as in the image above Fig. (266) Interaction page - Set the properties and enter the required data as in the image above Fig. (267) Interaction page - Set the properties and enter the required data as in the image above Fig. (268) 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. (269) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (270) Interaction page - Set the properties and enter the required data as in the image above Fig. (271) Interaction page - Set the properties and enter the required data as in the image above Fig. (272) Interaction page - Set the properties and enter the required data as in the image above Fig. (273) 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. (274) Component Browser – Select the component (ADO Open RecordSet) After selecting the component click Ok or press ENTER Fig. (275) Interaction page - Set the properties and enter the required data as in the image above Fig. (276) 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. (277) Component Browser – Select the component (Show Message) After selecting the component click Ok or press ENTER Fig. (278) Interaction page - Set the properties and enter the required data as in the image above Fig. (279) 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 (Button Class) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Class) Note : Stop typing when you see the required component is selected Fig. (280) Component Browser – Select the component (Button Class) After selecting the component click Ok or press ENTER Fig. (281) Interaction page - Set the properties and enter the required data as in the image above Fig. (282) Interaction page - Set the properties and enter the required data as in the image above Fig. (283) Interaction page - Set the properties and enter the required data as in the image above Fig. (284) 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 (Button Class) The fast way (Using Keyboard shortcuts): 1 - Get the component using its name by typing (Button Class) Note : Stop typing when you see the required component is selected Fig. (285) Component Browser – Select the component (Button Class) After selecting the component click Ok or press ENTER Fig. (286) Interaction page - Set the properties and enter the required data as in the image above Fig. (287) Interaction page - Set the properties and enter the required data as in the image above Fig. (288) Interaction page - Set the properties and enter the required data as in the image above Fig. (289) 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. (290) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (291) Interaction page - Set the properties and enter the required data as in the image above Fig. (292) Interaction page - Set the properties and enter the required data as in the image above Fig. (293) Interaction page - Set the properties and enter the required data as in the image above Fig. (294) 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. (295) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (296) Interaction page - Set the properties and enter the required data as in the image above Fig. (297) Interaction page - Set the properties and enter the required data as in the image above Fig. (298) Interaction page - Set the properties and enter the required data as in the image above Fig. (299) 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. (300) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (301) Interaction page - Set the properties and enter the required data as in the image above Fig. (302) Interaction page - Set the properties and enter the required data as in the image above Fig. (303) Interaction page - Set the properties and enter the required data as in the image above Fig. (304) 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. (305) Component Browser – Select the component (Textbox Class) After selecting the component click Ok or press ENTER Fig. (306) Interaction page - Set the properties and enter the required data as in the image above Fig. (307) Interaction page - Set the properties and enter the required data as in the image above Fig. (308) Interaction page - Set the properties and enter the required data as in the image above Fig. (309) 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 Define New Button ( btnUpdate ) , Caption : "Update" Button Events Event: ON CLICK : Action btnUpdate Button Properties Define New Button ( btnSave ) , Caption : "Save" Button Events Event: ON CLICK : Action update Button Properties End Of Window Activate window Define Procedure openDB Start Here win1.btnSave.Enabled := false 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 Define Procedure btnUpdate Start Here win1.btnSave.Enabled := true win1.btnUpdate.Enabled := false win1.txtPhone.BackColor := {128,128,255} win1.txtAddress.BackColor := {128,128,255} win1.txtPhone.ReadOnly := false win1.txtAddress.ReadOnly := false End of Procedure Define Procedure update Start Here Call Procedure conn name = win1.txtName.Value phone = win1.txtPhone.Value address = win1.txtAddress.Value Open Recordset oRS , Connection conn , CursorType 1 , SQL Statement "update contacts set phone= '"+ phone +"',address='"+ address +"' where name='"+name+"'" Show Message "Name : "+ name +" Updated Successfully..." Title "Success" Type: Message Box win1.btnSave.Enabled := false win1.btnUpdate.Enabled := true win1.txtPhone.BackColor := {255,255,255} win1.txtAddress.BackColor := {255,255,255} win1.txtPhone.ReadOnly := true win1.txtAddress.ReadOnly := true End of Procedure 4 - Application during the runtime Fig. (310) Application during the runtime Fig. (311) Application during the runtime Fig. (312) Application during the runtime
|