I was trying to troubleshoot some SQL statments. I counldn't figure out
what's going on until when I looked closely at the index name with a space
at the end.
There was no way for me to know if the index name had a space at
the end. I had to reverse engineer the table.

See my queries:
CREATE INDEX IF NOT EXISTS "Businessdate_IDX" ON "ParentGameIncomeItems"
("BusinessDate" DESC); and
CREATE INDEX IF NOT EXISTS "Businessdate_IDX " ON "ParentGameIncomeItems"
("BusinessDate" DESC);

The 1st query gave me the error message: DBISAM Engine error # 10027 the
secondary index 'Businessdate_IDX' already exists for the table
"ParentGameIncomeItems". Which is not correct. My table did have a secondary
index but it was called
"Businessdate_IDX "  with an extra space at the end.
I think this is odd, I am not sure if this was reported earlier but I really
think it's very confusing to alot of people.
Thank you,
-Halim

Halim,

<< I think this is odd, I am not sure if this was reported earlier but I
really think it's very confusing to alot of people. >>

I'll see what I can do about trimming up the identifiers.

--
Tim Young
Elevate Software
www.elevatesoft.com