Jim Lawrence
accessd at shaw.ca
Tue Jun 23 14:53:37 CDT 2009
Hi Arther: Yes there is. I have a friend, who is a bit of a guru in MS SQL and he built an entire database system using, and don't quote me, the EVAL() statement to use function names passed back and forth through the procedures. The whole thing ran like a object database; even the function names were stored in tables... very slick. I have a copy of the code but could not get it to work as some of the external processes were "C" and definitely not my forte. I will try and get you some more info when things quiet down. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, June 23, 2009 8:24 AM To: Access Developers discussion and problem solving Subject: [AccessD] Pseudo Pointer to a Function Is there a way to pass the name of a function or procedure to another one? The need for this might occur when the given procedure must branch in various ways, and call a proc/function whose name depends upon the code-path, as it were. Yes, one could write a CASE statement to deal with this, and that is exactly what my current code does. But it set me to wonder whether it's possible to pass the name of the function/procedure to call rather than code the CASE statement. A. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com