> 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.
