Kevin,
One big advantage to keeping a single connection for SQL-Server DB open is that you only need a single connection for all of your work on that DB - you can open your views shared and pass the connection handle in to all SQLExec() commands. Checking the connection isn't difficult - you just need to remember to do it.
Barbara
>I have a SQL/VFP design question
>
>I'm now using SQL 7 in my app, instead if VFP tables.
>
>For each user that starts an instance of my application, I was
>thinking of storing the connection handle from the SQLConnect command
>to a property on my App object, and maintaining that connection as
>long as that instance of my application is open.
>
>Any ideas on this?
>
>Thanks