No. Asynchronous/Synchronous has nothing to do with the number of connections. It has to do with whether or not the application waits for a result set to be completely returned before moving on.
>>Huh? I don't understand the question.
>>
>>>>No. Setting Asynchronous to .F. simple means that the application waits for the result set to be returned before continuing. In the case of sharing connections, this means that only one SQL process will be using the connection at one time, avoiding the dreaded "Busy" message.
>>>
>>>I get it. Am I right thinking that I have less simultaneus processes having Synchronous connections?
>
>I mean, syncrhonous connections uses less "connections". If i have this secuence:
>
>requery (view1)
>
>requery (view2)
>
>requery (view3)
>
>in an asynchronous connection, I'm using 3 connections (if the querys are long enought).
>
>in a synchronous connection, I'm reusing one connection 3 times.
>
>Is that OK?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05