Re: .mdb file + :odbc + drop-index => belly up

Jason H wrote:
> After creating an index with:
>   (create-index [cftypeid] :on [cellfeature] :attributes '([typeid]))
> either
>   (drop-index [cftypeid] :on [cellfeature])
> or
>   (drop-index [cftypeid])
> will drop me into the debugger:
>
>   A database error occurred: NIL / 42000
>   [Microsoft][ODBC Microsoft Access Driver] Syntax error in DROP TABLE
> or DROP INDEX.
>   [Condition of type SQL-DATABASE-ERROR]
>
>   Backtrace:
>   3: (ODBC-DBI:SQL "DROP INDEX CFTYPEID")[:EXTERNAL]
>
> More background info:
>   1. CLSQL 4.3.0
>   2. SBCL 1.0.33.4 win32  
>   3. Using :ODBC database type to clsql:connect to a .mdb file.

It looks like it is issuing just "DROP INDEX CFTYPEID", which appears to
be incorrect for Access: http://www.w3schools.com/SQl/sql_drop.asp

My guess is when you use the
(drop-index [cftypeid] :on [cellfeature]) variant you get "DROP INDEX
CELLFEATURE.CFTYPEID"  or is the actual sql expression the same whether
you provide :on or not?