Eric, What are clustered/non-clustered indexes as related to RBase and Sql?
Ben Petersen On 4 Oct 2001, at 14:19, Crued @ Crued.net wrote: > 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/ > >
