I've got a VFP program which is installed at 2 separate community Mental Health Facilities. Recently, I added some ODBC connections to a special DBC set up to just handle the remote views to the SQL Anywhere files. I am getting lockups at 3 of the 5 workstations at one site, and no lockups (out of about 10 workstations that run it) at the other site.
The facts:
1. Sybase SQL Anywhere Database Engine Version 5.5.04 Build #1980
2. The DBC was used prior to this last revision (of the VFP program) that I sent them. There were no problems prior to the latest revision.
3. It appears to lock up every time it closes the connection (SELECT PATIENTS/USE) on any of the screens which use the DBC. I don't have the tables in the data environment because they might not use those tables (if they don't have the SQL Anywhere program, it doesn't attempt to use the files). So, in the Destroy method of the form, I have a
IF USED('Patients')
SELECT Patients
USE
ENDIF
Any help would be appreciated.
Joy Ruhe
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488