One more thing you could use. Under Layout ON BEFORE DESGN ACTION, that would be a good place to create your temporary table and add a couple of test records and, ON AFTER DESIGN ACTION, you can drop the temporary table. Javier, Javier Valencia, PE 913-915-3137 From: [email protected] <[email protected]> On Behalf Of Bruce Chitiea Sent: Friday, October 15, 2021 4:11 PM To: [email protected] Subject: Re[2]: [RBASE-L] - Form Design | ENTER and EDIT Modes All points granted, and S.O.P. in my shop. The blind spot is when designing a form for which the bound temp table is empty, [CTRL-F9], which is natively in EDIT mode, finds nothing to EDIT in the table, and BYPASSES [1] the ON BEFORE EEPs, delivering only the 2059 error. Understood. In later stages of testing, I can start the form with ENTER USING; but during the rough-and-ready design stage, there's no ENTER USING formname OPTION DESIGN to accomplish the task. Bottom line, if there's no analog to the imaginary PROPERTY <formName> ENTER_MODE 'TRUE', then I'm perfectly fine with using the [Shift-Ctrl-F9] approach. [1] Neither of the On Before EEPs, with TRACE active, appears. Much appreciated, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA [email protected] <mailto:[email protected]> | +011 (909) 238-9012 c | +011 (909) 912-8678 f ------ Original Message ------ From: [email protected] <mailto:[email protected]> To: [email protected] <mailto:[email protected]> Sent: 10/15/2021 12:44:47 PM Subject: RE: [RBASE-L] - Form Design | ENTER and EDIT Modes Bruce, When I ma working on a form I use one of two methods to test. One is clicking the blue right arrow or (Ctrl-F9) which saves the current version and opens the form in the edit test mode. The other is clicking the thunderbolt icon (Shift-Ctrl-F9) which will not save the changes made since the form was last saved but gives you the option of selecting the mode, Edit or Enter, and allows you to select WHERE and Sort Clauses and stores a history of them. I find it extremely handy when I need to test a form with a specific, long selection clause since I can just pick it up from the list. Again, you need to save your form if you want to test the changes made when using the second option. Javier, Javier Valencia, PE 913-915-3137 From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of Bruce Chitiea Sent: Friday, October 15, 2021 11:06 AM To: [email protected] <mailto:[email protected]> Subject: [RBASE-L] - Form Design | ENTER and EDIT Modes RBGX5E 10.5.4.11007 QUESTION: For design/testing purposes, which PROPERTY, when defined within a Form's On Before Design Action/On Before Start EEPs, will set the Form into ENTER mode? BACKGROUND: While designing a Form bound to a TEMP Table; - intended strictly for data entry one row at a time; - during testing within a design session; - where the Temp Table is empty; - where both On Before EEPs have TRACE set ON: (1) when hit, the [Ctrl-F9] "Run Form" (blue triangle icon): - skips both On Before EEPs; - returns error: "No rows exist or satisfy the specified clause. (2059)" ... as if "Run Form" operates strictly in EDIT mode. (2) when hit, the [Shift-Ctrl-F9] "Run Form Live" (lightning icon): - displays the Run Form <formname> dialog; - runs the On Before EEPs no matter which mode is chosen; - succeeds when ENTER is chosen; - fails with 2059 when EDIT or BROWSE are chosen (as expected). Thanks much. Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA [email protected] <mailto:[email protected]> | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emaba3dec6-a43a-408e-916a-e629e305f518%40pathfinder <https://groups.google.com/d/msgid/rbase-l/emaba3dec6-a43a-408e-916a-e629e305f518%40pathfinder?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAGhPjYCaf5RGqUdCYme3pHsBAAAAAA%3D%3D%40vtgonline.com <https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAGhPjYCaf5RGqUdCYme3pHsBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em03822fba-42b2-4c6c-b4a9-659af13cfbff%40pathfinder <https://groups.google.com/d/msgid/rbase-l/em03822fba-42b2-4c6c-b4a9-659af13cfbff%40pathfinder?utm_medium=email&utm_source=footer> .
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAFOmq95vvtRJjA4s5QckDaYBAAAAAA%3D%3D%40vtgonline.com.
