>Upon further review of the Help file. I think this is what they really mean.
>
>If you use SQLSTRINGCONNECT to create your connection, but the connection is NOT sharable, you can use SQLSETPROP to make that connection sharable (set Sharable to .T.). You must then issue a SQLCONNECT and pass that original handle as the only parameter to get a truly sharable connection which results in a NEW handle that you can use with views, etc. By passing the handle created by SQLSTRINGCONNECT in the SQLCONNECT function, you are telling VFP to create this new handle using the current properties of the original connection.
>
>Your situation and the explanation confused me because I create my connections using SQLSTRINGCONENCT all day long and NEVER have a sharing problem because when I create the connection, I am making it sharable from the very beginning. So opening multiple CAs, views and using SPT has never created an error when using this same connection for all of it.
>
Hi Mark,
Disregard my previous posts. My problem isn't with the connection, its something to do with a view. I can open multiple views until I get to one paricular view, v_Label. After that I can't open any others but the error message that gets generated indicates the error is occurring when I try to open the next view.
Sorry for confusing things,
Jim