In the Acce$$ db, create a view with shorter column names, and use that from R:Base
"Crued @ Crued.net" <[EMAIL PROTECTED]> 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/ > > __________________________________________________________________ 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/
