>Once I have issued a SQLStringConnect() to connect to a specific SQL Server database, does this connection will remain effective, as long as the program runs and as long as I don't close or that is bound to a specific timeout, and without inactivity, when the timeout occurs, the connection will be lost?
>
>I'm looking for get as close as having a table to be permanently opened at the startup of an application in VFP, with VFP native table, and I was wondering how close I could get to that with SQL Server.
Having the connection opened has not the same effect as having a table opened. It all depends of the purpose of your actions. If I want to have only one user at a time working with given table I'm setting the TRANSACTION ISOLATION LEVEL to SERIALIZABLE and then I execute any necessary SELECT and/or UPDATE/INSERT statements. What do you want to achieve holding the table opened all the time when application works?
Venelina Jordanova
Outsourcing IT Services Ltd.