Hi Mark,
Doesn't make sense to me, either. But that seems to be the way it works.
BOb provided the answer on F1 Technologies VFE Forum. Here is the text of his message:
"I argued about this in the beta and they just didn't listen to me. This is from the Doc, it might help:
SQLSTRINGCONNECT( ) always creates a new connection when it successfully makes a connection. However, setting the lShared parameter determines whether you can share the connection later. If you specify a connection as shareable by setting lShared to True (.T.), you can share the connection later by calling SQLCONNECT( ) and passing the numeric value of the connection handle as the first parameter. For more information, see SQLCONNECT( ) Function.
You can use SQLCONNECT( ) to obtain a new statement handle on a shared connection that was opened using SQLSTRINGCONNECT( )."
Regards,
Jim