Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View - Connection is Busy
Message
From
22/11/2004 12:00:07
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
 
To
19/11/2004 08:59:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00960626
Message ID:
00963529
Views:
14
I appreciate the response; could you elaborate on 'fetched handles' and why not to share them?

Thanks!

>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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform