Hi Dan, Given what you say I have no idea what the problem is. I would definitely double check for the column names. There are always some tables in an R:Base database- the system tables. Try the command again and if you get an error then at the R> prompt type
list col DISCOUNT and see what comes up. Best regards, Mike Young On Wed, 20 Mar 2002 15:44:28 -0600, Dan Weissmann wrote: >Well, not exactly, as there are no tables in the Rbase db. I created the >Rbase db and tried to connect to a table in the Sybase db. > >Also, FWIW, I have no control over the Sybase db as it's part of a company >wide application designed by a third party. So changing column names isn't >an option. In the past I've done some fancy import work, but if Rbase is >supposed to be able to connect to a foreign source, I'd rather do that. > >----- Original Message ----- >From: "Mike Young" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, March 20, 2002 1:30 PM >Subject: Re: Help With Forms - Razzak's Reply > > >> 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/ >> >> > >================================================ >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/
