General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
It takes time to retrieve data into alias remote. So to continue you may need to check the connection ConnectBusy property (see sqlgetprop() function for more details) or just check when the number of records in the remote does not change anymore.
Something like:
use testdata!my_remote_view alias remote
lnrec=-5
do while lnrec#recc()
lnrec=recc()
wait wind time 1.0 "Please, wait..."
enddo
>Hello
>
>I' trying to insert some data into a remote view.
>
>this is the way i go about it. This code is in an onclick event
>
>use testdata!my_remote_view alias remote
>* wait window 'wait a bit'
>insert into remote (cols) values (values)
>
>This only works WITH the wait window command
>otherwise I get an "connection remote_01 is busy" error.
>
>Can anyone tell me what's going on here?
>
>tia
Previous
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