468,145 Members | 1,380 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,145 developers. It's quick & easy.

Retrieving procedure and form names

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

Jul 10 '07 #1
1 1606
On Tue, 10 Jul 2007 08:24:20 -0700, "Chris L." <di******@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
Jul 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Girish | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.