By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,478 Members | 1,833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,478 IT Pros & Developers. It's quick & easy.

Retrieving procedure and form names

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.