It's not the VarChar that prevents the creation of the tables, it's that it uses CLUSTERED and NONCLUSTERED Indexes. Having so many problems getting this working that I failed to think about what the problem really was.
I think this means I owe someone a quarter, or a pair of socks or something, but I'm not sure how that works. :) Eric >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. > -----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/
