Hi, I'm trying to set up a generic mechanism that would allow the
following:

1: Run <this_procedure>
2: After that, run <this_review_procedure>
3: If it returns non-zero, open <this_form>

The idea is that the first procedure would have to update records.
After that, the review procedure would check if there are unupdated
records. If there are, a form would open to show the problem records,
for user review.

So I would need to store in a metadata table: the procedure name, the
review procedure name and the form name, for example:

"update_yesterday_sales",
"check_for_unupdated_sales",
"frmShow_unupdated_sales"

"update_repaired_parts",
"check_for_unrepaired_parts",
"frmShow_unrepaired_parts"

And I would have a generic process running thru the records of this
table and running all defined processes in sequence. At some point,
the idea is present the user with the processes list and let the user
choose (checkboxes I hope) which processes s/he wants to run.

My question: Is it possible to retrieve a form's name from a table and
show the form? Ditto for retrieving a procedure name and executing it?
Do you have any pointers and/or examples to show me?

Very thankful in advance
Regards,
Chris

On Tue, 10 Jul 2007 08:24:20 -0700, "Chris L." <diversos@uol.com.ar>
wrote:

"Eval" is your friend. Look it up in the Help file.

-Tom.

>Hi, I'm trying to set up a generic mechanism that would allow the
>following:
>
>1: Run <this_procedure>
>2: After that, run <this_review_procedure>
>3: If it returns non-zero, open <this_form>
>
>The idea is that the first procedure would have to update records.
>After that, the review procedure would check if there are unupdated
>records. If there are, a form would open to show the problem records,
>for user review.
>
>So I would need to store in a metadata table: the procedure name, the
>review procedure name and the form name, for example:
>
>"update_yesterday_sales",
>"check_for_unupdated_sales",
>"frmShow_unupdated_sales"
>
>"update_repaired_parts",
>"check_for_unrepaired_parts",
>"frmShow_unrepaired_parts"
>
>And I would have a generic process running thru the records of this
>table and running all defined processes in sequence. At some point,
>the idea is present the user with the processes list and let the user
>choose (checkboxes I hope) which processes s/he wants to run.
>
>My question: Is it possible to retrieve a form's name from a table and
>show the form? Ditto for retrieving a procedure name and executing it?
>Do you have any pointers and/or examples to show me?
>
>Very thankful in advance
>Regards,
>Chris