Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Space character at the end of index name |
Tue, Feb 5 2008 11:35 PM | Permanent Link |
"Halim Boumedjirek" | 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 |
Wed, Feb 6 2008 1:56 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |