----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, June 02, 2005 4:03 PM 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... Not that I know of... > 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. >
