General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Doesnot transfer data from remote view to local table
I am connected to a remote SQL server through the connection called Myconnection. Using this remote connection I have created a remote view to access all the records from one table in SQL server(_4_claim_temp_header. Now when I transfer the data from the remote view called 'rv__4_claim_temp_header' to a local table called _4_claim_temp_header, it transfers only part of total data from remote view. I'm using the following code to do that.
close databases
open database pinnapp
use rv__4_CLAIM_TEMP_HEADER
SCAN
SCATTER MEMVAR
INSERT INTO _4_CLAIM_TEMP_HEADER FROM MEMVAR
ENDSCAN
there is more than 13000 records in the remote table but I can see only 944 records in the Local Table. Any help
Thanks
Bharat
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