Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View - Connection is Busy
Message
De
19/11/2004 08:59:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
À
11/11/2004 15:44:43
Irv Adams
MSC Managed Care, Inc.
Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00960626
Message ID:
00962955
Vues:
12
If you share this sql server handle with a fetched cursor you have to needed end to fetch (go bottom etc.) . Don't share fetched handles.

>UT Experts:
>
>I am using Remote Views created to read/write to MS SQL, which are opened in the DE of various Forms to update fields via ControlSource. A Listbox refreshes the contents of all Textboxes using 'Requery()' in the Interactive Change event.
>
>All is well until I do an APPEND BLANK to the View. The command works and I can enter data into the Textboxes. However, after that, any Requery will result in 'Conection Connect1 is busy' and the program cannot continue. However, the data will be saved in the MS SQL table.
>
>Any ideas on this one, Thanks!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform