Ah yes, back to this "we used to" situation. It's 2001, not 1991. 10 years ago, 40 meg hard drives were fine. 10 years ago, 4 MB RAM was fine. 10 years ago, 286 processors with no math co-processor, and no L2 cache was fine. 10 years ago, 8 characters was fine. 'Back in the day' is not now. Now is the age of 32-bit, soon to be 64-bit.
It's time to move on to Pentium computers, 32 megs of RAM, and greater than 18 character column names. Eric > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Dennis Fleming > Sent: Friday, October 05, 2001 8:35 AM > To: [EMAIL PROTECTED] > Subject: RE: RE: Name length limitation > > Eric, > > >I find it extremely frustrating and downright lame that Rbase only > >allows 18 char column and table names. > > Seems a bit harsh, Eric. For most of us who some how managed to develop > some fair good RBase applications back in the days of only 8 character > column/table names. > > Dennis > ***** > > > > At 02:05 PM 10/4/01 -0500, you wrote: > >I find it extremely frustrating and downright lame that Rbase only > >allows 18 char column and table names. In addition to that horrible > >limitation, I found another. Rbase doesn't use standard SQL datatypes, > >so the automatic table creation from the Fax application does not work. > >Where it would say MyKey VARCHAR(19), Rbase wants MyKey TEXT 19. > >Lameola. > > > >Thanks for the suggestion though. The application can use an Access DB > >natively, but being that the Access DB will have the Fax application's > >required column names; will Rbase allow *my* app to issue SQL against > >column names it considers illegal? > > > >Thanks, > >Eric > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > >On > >> Behalf Of Albert Berry > >> Sent: Thursday, October 04, 2001 1:28 PM > >> To: [EMAIL PROTECTED] > >> Subject: RE: RE: Name length limitation > >> > >> I was asking if the fax program itself had a db, in which you could > >create > >> a view - but it looks like that is not what happens at all. In this > >case, > >> your best bet might be to create a M$ acce$$ db to receive the SQL > >> statements and SATTACH the acce$$ db to the R:Base db. > >> > >> > >> "Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: > >> > >> >The fax program's source database would be our Rbase database. I > >could > >> >create a view inside the Rbase DB, but I'm not sure what you are > >getting > >> >at doing with it. Due to the fact that the Fax application issues > >> >direct SQL to the ODBC driver, I don't think wrapper views would > >work. > >> >If you are thinking of some other solution, please let me know as I'm > >> >screwed otherwise. > >> > > >> >Thanks, > >> >Eric > >> > > >> > > >> >> -----Original Message----- > >> >> From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED]] > >> >On > >> >> Behalf Of Albert Berry > >> >> Sent: Thursday, October 04, 2001 12:28 PM > >> >> To: [EMAIL PROTECTED] > >> >> Subject: RE: Name length limitation > >> >> > >> >> Can you create a view in the fax program source database that > >renames > >> >the > >> >> fields to 18 characters or less? > >> >> > >> >> > >> >> > >> >> "Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: > >> >> > >> >> >Our Fax program can use an ODBC source for archival purposes. The > >> >> >tables that it uses are hard coded into their program, and some of > >> >the > >> >> >field names are longer than 18 characters. > >> >> > > >> >> >Is there anyway around this? > >> >> > > >> >> >Thanks, > >> >> >Eric > >> >> > > >> >> > > >> >> > > >> >> > >> >> > >> >> __________________________________________________________________ > >> >> Your favorite stores, helpful shopping tools and great gift ideas. > >> >> Experience the convenience of buying online with Shop@Netscape! > >> >> http://shopnow.netscape.com/ > >> >> > >> >> Get your own FREE, personal Netscape Mail account today at > >> >> http://webmail.netscape.com/ > >> > > >> > > >> > >> > >> __________________________________________________________________ > >> Your favorite stores, helpful shopping tools and great gift ideas. > >> Experience the convenience of buying online with Shop@Netscape! > >> http://shopnow.netscape.com/ > >> > >> Get your own FREE, personal Netscape Mail account today at > >> http://webmail.netscape.com/ > > > > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com
