FoxPro Programming
Re: A question about SQL handles
03/18/2010
06:08:38 AM
2W30D667P Show this entire thread in new window
Gratar Image based on email address
From:
Brandon Harker
To:
Douglas Osborne 
Attachments:
None
What is the best practice to get the SQL handle count down? It has been awhile since I've been in VFP code, let alone VFP 8.

Use a public object/property like goApp.nSQLHandle or a public variable like gnSQLHandle to share the SQL handle across your application. Your application should ideally have a single connection to the SQL Server/