Board index » delphi » Adaptive Server Anywhere 6.0 Indexes

Adaptive Server Anywhere 6.0 Indexes

I'm trying to add/delete indexes on a SQL Anywhere 6.0 database using
ttable.addindex/ttable.deleteindex and get an exception.  I can add and
delete using Paradox, so I assume that there is some direct dbi calls being
made.  Does anyone have any experience with this?
 

Re:Adaptive Server Anywhere 6.0 Indexes


I have a similar problem with indexes in ASA6.  I've used a variety of
methods to upsize an existing Paradox database to ASA6 through ODBC - using
Paradox copy table, TTable.CreateTable, Datapump etc.  Some of our indexes
are created in the ASA target table,  some are not .  I'd be very interested
in anyone's experiences of this......particularly how to create the indeces
without doing it manually or having to write an app to generate the SQL to
do it.  (I have D4 c/s coming this afternoon and am hoping that this may
have some tool that works !!)
Quote
David Wood wrote in message <7aqj1g$o...@forums.borland.com>...
>I'm trying to add/delete indexes on a SQL Anywhere 6.0 database using
>ttable.addindex/ttable.deleteindex and get an exception.  I can add and
>delete using Paradox, so I assume that there is some direct dbi calls being
>made.  Does anyone have any experience with this?

Other Threads