Hello,
I was trying to figure out the drop index syntax for your driver
create table tst (val varchar(50) default null)
create index tstidx on tst (val)
This fails with a parse error:
drop index tstidx
This fails with another error
drop index tstidx on tst
What is the correct syntax?
Thanks,
Rob
|
DROP INDEX ALL of "tst.idx" ON tst
|
The index is called tstidx, not idx.
Both of the following fail with a nullpointer:
DROP INDEX ALL of "tst.tstidx" ON tst
DROP INDEX ALL of "tstidx" ON tst
Error: java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.i.a(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.execute(Unknown Source)
|
Try
DROP INDEX ALL of "tstidx" ON tst
or
DROP INDEX ALL of "tstidx.idx" ON tst
The latest package will mask that NullPointerException.
|