At 12:54 PM 3/20/2002 -0600, Dan Weissmann wrote: >When I try to attach a table, I get the following error messages: > >Cannot attach a DOUBLE column to existing column DISCOUNT of type NUMERIC > >Cannot attach an INTEGER column to existing column MINORBASE of type NOTE >(2946) > >and so on. > >If I try to attach just one column, I get the same set of error messages. > >Apparently, the table shows up in the table list but when clicking on it, it >reads No Qualifying Rows Found.
Dan, See Mike Young's reply for a brief explanation of those -ERROR- messages. R:BASE is a True-Relational Database and will NOT allow two columns with same name but different data type in the same database. If you are using R:BASE 2000 (ver 6.5++) for Windows, Build:1.851xRT03, then, you should take advantage of the ENHANCED SATTACH command to achieve your goal. One of the MAJOR ENHANCEMENTS in 6.5++! Example: SATTACH [TableName [AS TableAlias] [USING ColumnList] [ALIAS AliasList]] . [AS TableAlias] specifies an alias, or temporary name, for the foreign table. . [USING ColumnList] If the foreign table has no primary or unique key, specifies the column(s) that uniquely identify the rows in the table. . [ALIAS AliasList] to specify alias names for columns. Using the latest version, if the name conflicts with another name then you get the error message first explaining the conflict, then the dialog box for ALIAS Column Name to avoid any conflict and still maintain the INTEGRITY of a True-Relational Database! Hope that helps! Enjoy and make sure to have fun! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
