Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
Fabio:
I use the default Asynchronous = .F. in SqlSetProp(), should I try changing that?
Also, this is interesting about =reccount(); how does that prevent the busy connection?
Thanks !
>>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!
>
>Use You Async statement ?
>
>If no, before APPEND BLANK put a =RECCOUNT()
>
>Fabio
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement