I went to this school recently ...
The USING portion of the SATTACH does not specify the columns to include but rather the columns that uniquely identify a row. R:Base will then build indexes on those columns. You get all the columns in the table whether you want them or not. The ALIAS portion after the USING portion will assign aliases to the columns in the table, so you need to include an alias for every column in the SATTACHed table.
Naturally, the superior method is to build a view in the foreign database with the columns you want named the way you want them, and SATTACH that.
I have SQL database that I'm attaching to a table EMP (EMPLOYEE INFORMATION) that has a column named ZIP. When I do this I get a dialog box that ask me to give that column an alias.I'm using this below. Sattach EMP as EMPINFO using EMPCODE,FIRSTNAME,LASTNAME,ZIP alais USERID,FNAME,LNAME,ZIPCODE Is there any way to stop this dialog box request? I'm using Patch three haven't updated to four yet! Best regards, Oma Cox
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
