I see in your example, you do not use the word KEY. But the unload inserted
it.
also you are using idquotes, but it worked without it.
Is the word key the problem?
----- Original Message -----
From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 13, 2010 9:47 PM
Subject: [RBASE-L] - Re: Syntax error when reloading a table 7.6
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.
