Category : Paradox DBMS
Archive : TECH91.ZIP
Filename : TI592.ASC
Output of file : TI592.ASC contained in archive : TECH91.ZIP
PRODUCT : PARADOX/SQL-LINK NUMBER : 592
VERSION : 1.0
OS : DOS
DATE : September 11, 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.
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/