If you use this approach in the VarChar column you can place the call to the Rbase_Form_Action. That way all the code ends up in the same form it would just need an external call so that all the code can be accessed.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Posted At: Thursday, June 02, 2005 4:03 PM Posted To: RB7-L Conversation: [RBG7-L] - Re: Form Questions... Subject: [RBG7-L] - Re: Form Questions... Thanks Mike, this is along the lines of what I need. I have one question: is it possible to use the same approach to run a Custom Action stored in the form from the "after Saving Row" command line? If yes, then all the code would be stored within the form... Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of MikeB Sent: Thursday, June 02, 2005 1:17 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Form Questions... > has anyone figure out a > way to do this from an internal EEP? Javier, I have posted this solution a couple of times, but here goes: 1. Create a table Like: CREATE TABLE `IntCmd` + (`CmdName` TEXT (18) NOT NULL + ('Value for column CommandName cannot be null') , + `CmdData` LONG VARCHAR NOT NULL + ('Value for column CommandData cannot be null') ) ALTER TABLE `IntCmd` ADD PRIMARY KEY + (`CmdName` ) + ('Values for rows in MyCommandTable must be unique',+ 'Cannot delete - values exist in another table',+ 'Cannot update - values exist in another table') COMMENT ON TABLE `IntCmd` IS + 'Table to Store Internal Commands for EEPs' 2. In the CmdName Column insert the Unique name to be associated with our "PSuedo" EEP and insert the Actual EEP in the CmdData column. 3. Open your form in the Designer that you want to have Table Level EEP to call. 4. Open the "Table Settings" 5. In the Edit box next to one of the table level Events (On Row Entry, On Row Exit, After Saving Row, After Leaving Sec), Place code that has this format: SELECT CmdData FROM IntCmd WHERE CmdName = 'TheNameOfThePsuedoEEP2Run' Your code will execute. Keep the "CmdName" length frugal to not exceed the Character limit that is passed to the "Run" command (that is what happens to stuff that is put in this location) Explanation: The code executes as if you had called a "Run Select" from the command line or in Code.
