Hi Derek,
usually, this is what we do. However it depends on the number of accesses you have while your app is in use. As most of our input fields make use of db contents, for us it is essential to leave the connection open. Do you only need sqlexec when starting your app an for saving/modifying records every few minutes, then it might make sense, to close your connection immediately after usage.
>Tom
>
>Are you saying that it's best to create an application level connection to the remote SQL source (which is on the same local network as the application PC's) and leave it open for as long as the local VFP application itself is open?
>
>Regards
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011