Retrieving procedure and form names

[Chris L.]

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_pr ocedure>
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_yesterd ay_sales",
"check_for_unup dated_sales",
"frmShow_unupda ted_sales"

"update_repaire d_parts",
"check_for_unre paired_parts",
"frmShow_unrepa ired_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

[Tom van Stiphout]

On Tue, 10 Jul 2007 08:24:20 -0700, "Chris L." <di******@uol.c om.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_pr ocedure>
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_yester day_sales",
"check_for_unu pdated_sales",
"frmShow_unupd ated_sales"

"update_repair ed_parts",
"check_for_unr epaired_parts",
"frmShow_unrep aired_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