Re: .mdb file + :odbc + drop-index => belly up
Jason H <[email protected]>
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
On Sun, Jan 31, 2010 at 9:38 AM, Nathan Bird <[email protected]>wrote: > 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? > > Confirmed by START-SQL-RECORDING, the actual sql expression is always "DROP INDEX CFTYPEID" whether :ON is provided or not. Right now, I just use (QUERY "DROP INDEX an-index ON a-table"). Best, Jason _______________________________________________ CLSQL mailing list [email protected] http://lists.b9.com/cgi-bin/mailman/listinfo/clsql