Hi Razzak,
I'm not sure what version of 7.6 he has but he got it about 6 or 8 months
ago (Roto Rooter).
Originally it was converted from 2.11 but when he lost one of the tables in
7.6 we recreated it from an old backup of 7.6 So the unload was from 7.6
----- 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.
