home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-385-Vol-1of3.iso
/
t
/
tech91.zip
/
TI592.ASC
< prev
next >
Wrap
Text File
|
1991-08-26
|
1KB
|
67 lines
PRODUCT : PARADOX/SQL-LINK NUMBER : 592
VERSION : 1.0
OS : DOS
DATE : August 26, 1991 PAGE : 1/1
TITLE : Viewing remote tables
Tables located on the SQL Server (remote tables) can sometimes be
several megabytes in size. Therefore viewing, updating, and
screen refreshing these tables in a client server environment can
cause a great deal of network traffic. By creating a query,
though, we can view a copy of the SQL table and avoid excess
network traffic.
After establishing a connection to your SQL server, create a
replica of the remote table using the SQLSetup script. Then
select [F10] ask and enter the remote table name. Place a
CheckPlus ( [Alt] [F6] ) in every field of the query form, and
press [F2] Do-it!. SQL-Link will translate the query and send
the SQL code to the server. The server then optimizes the query,
processes it. and sends the result to a local answer table. This
answer table can then be modified, used in a local query, or
updated and added back into the remote SQL table.