I want to try DBSetProp, but my problem is that I make the connection with SQLCONNECT not with a connection in a .DBC so I don't have a name for my connection. And I don't saw the same command with SQLSetProp. So is it possible to do it with a connection create by SqlConnect ?


>Just to answer my own question, I tested DBSETPROP() to see if it really does do it on the fly and the answer is yes.
>
>>I always forget about that. But does it really happen on the fly, or does VFP drop the connection, change the DB, and then reconnect? That could be a bit of a performance hit. You're absolutely right about the stored procedure. In fact, it's probably the best solution (IMHO) speed wise.