Razzak and Emmitt! Razzak - I'll up date to the latest patch and see what happens!
Emmitt - I would love to create a view in the db but I'm not allowed to do anything because it's a can application using SQL DB engine and the owners will not allow me to modify or add anything to the DB. I'll try what has been advised! Best regards, Oma -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Emmitt Dove Sent: Thursday, February 06, 2003 3:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SATTACH Oma, 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]
