General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only