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/
