At 08:12 PM 7/13/2010, Bernard Lis wrote:
When you unload structure for a table, the following results in
an error when reloading the structure:
CREATE INDEX Invoice Key ON `Resd2` (`InvoiceNumber` ASC)
-ERROR- Syntax is incorrect for the command CREATE (2045)
If you change the command to this, it works:.
CREATE INDEX Invoice ON Resd2 (InvoiceNumber)
This is using 7.6
Bernie,
What update and build of 7.6?
A question and a suggestion:
01. Was this database converted/upgraded from a legacy version of R:BASE?
If yes, did you ever use the UNLOAD/LOAD process to re-build a
fresh database?
When upgrading a legacy database, it is strongly recommended to
use UNLOAD/LOAD method to re-build a database. Using this approach,
with the latest versions/updates of R:BASE will always make all
structural data in compliance with the current engines.
Correct Syntax:
-- When Indexing Text Columns
CREATE INDEX indexname ON `tablename` (`colname` ASC SIZE nn)
CREATE INDEX indexname ON `tablename` (`colname` DESC SIZE nn)
-- When Indexing Non-Text Columns
CREATE INDEX indexname ON `tablename` (`colname` ASC)
CREATE INDEX indexname ON `tablename` (`colname` DESC)
02. Take a look at the following technical article for complete details:
Article: Database Maintenance (R:BASE 7.6 for Windows)
Posted: 12/29/2008
From The Edge: http://www.razzak.com/fte/
Very Best R:egards,
Razzak.
