Eric -
You haven't answered Ben's question: What are
clustered/non-clustered indexes as related to RBase and Sql? Or in other
words, what is the difference between clustered and non-clustered indexes?
Bernie
=======================================
At 11:02 AM 10/5/2001 -0500, you wrote:
>The application sets up the tables it needs inside the database you
>specify. In my case, Rbase via Oterro. The commands the application
>use specify whether the index is a clustered or a non clustered index.
>Rbase considers it an invalid command. This is in addition to the fact
>that the application needs column names larger than 18 characters, so it
>doesn't matter in the grand scheme of things. It would be nice if the
>application let you specify your own table names, but that would require
>much more work on their end and I don't blame them.
>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>On
>> Behalf Of Ben Petersen
>> Sent: Friday, October 05, 2001 2:54 AM
>> To: [EMAIL PROTECTED]
>> Subject: RE: RE: Name length limitation - personal correction
>>
>> 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/
>> >
>> >
>
>
