Kind of along the same lines, I was trying to setup an environment for SQLSetProp(), using a table to manage the style of connection I need. What would you recommend for setting a variables type based on another column name?

My table looks something like this:

   cPropName         cPropType       cPropVal
   'Asynchronous'        l              .f.
   'Comment'             c              ''
   'ConnectTimeOut'      n               15

I figure'd I would scan through the table, and do SQLSetProp with each cPropValue:

   SQLSetProp(nConnHandle,cPropName,cPropVal)

But since the cPropVal column is a char type, and my back end is expecting char/num/logical, things choke. I thought I'd make a little do case thing with transform() and cPropType but nothing is coming together.

What do you think?