how to run a function depending on situation

[sixtoedsloth]

HI,

im not sure if this is possible....


i want to store in a databse the name of a function
that is to be run. when the user logs in the code looks in the database for that user, retrieves the function name and runs it. any ideas how to do this?

Cheers

Russ

 

[Golom]

There is the "CallByName" function that executes a method or property of an object (check VB help for that.) I would however be somewhat leery about storing actual internal Sub or Function names in a database. If you do, you now become bound to database contents when maintaining your application. I would look into a case statement that allows you to associate a value in the database with a specific function or sub. Something like

Select Case [ActionField]
   Case "Save"
      Value = FuncSave (Parm1, Parm2, ...)
   Case "Compute"
      Value = FuncComp1 (Parm3, Parm4, ...)
etc.