Hi Dan, My guess is that you have 2 columns with same name and different datatypes in the 2 databases. R:Base can only have one datatype for a column name. You can probably use the ALIAS command in your attach clause to give R:Base the ability to rename the problem columns This is only available in the newer versions.
Best regards, Mike Young On Wed, 20 Mar 2002 12:54:20 -0600, Dan Weissmann wrote: >Razzak, > >Need your help on step 1, > >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. > >Thanks, >Dan > > > >----- Original Message ----- >From: "A. Razzak Memon" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, March 18, 2002 5:46 PM >Subject: Re: Help With Forms - Razzak's Reply > > >> At 04:05 PM 3/18/2002 -0600, Dan Weissmann wrote: >> >> >I'm trying to write a program that, >> > >> >1. Links to a Sybase table, and then >> > >> >2. Prints customer information on a series of odd sized (14.5 lines per >> >page) continuous forms. >> > >> >Can anyone assist me in (#2), which is the most critical part of the >> >process. I'll need to have complete control of the output, as I keep >getting >> >strange errors when trying to print via Word (one form is printed and >then >> >it form feeds). Also, whenever I use a custom form set up for the >printer, >> >RBase (6.5+), RBase crashes on me. >> >> Answer to your question 1: >> >> 01. Create a Systems DSN using Sybase ODBC driver, then: >> use the following commands in R:BASE for Windows: >> >> SCONN DSNName IDENTIFIED BY UserID Password >> >> SATTACH [TableName [AS TableAlias] [USING ColumnList] [ALIAS >AliasList]] >> >> For more details and examples: http://www.RSyntax.com >> >> 02. The Glorious R:BASE 2000 (ver 6.5++) for Windows, Build:1.851xRT03, >> includes the ENHANCED PRNSETUP command to specify 'Paper Size' >> as well as the 'Paper Source' to automate entire task. >> >> If you are trying to print via Word, you'll need to setup a System >> DSN for >> R:BASE 2000 Database using R:BASE 6.5++ ODBC Driver or OTERRO >> 2000 (ver 2.5) Driver to access R:BASE Database. >> >> 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/ >> >> > >================================================ >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/ ================================================ 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/
