Tim

I typed

CREATE INDEX IF NOT EXISTS "Name" ON "Memory\tmpfile" (_List;_Name);

ie with a ; rather than a ,

The error generated says there's a missing bracket

Roy Lambert

I assume thats because it thinks the end of the SQL statment was after
_List; , therefore it says missing bracket and it assumed ,_Name) was a new
SQL statement.

I reckon the error message is correct


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:A7407760-6BF4-4490-8115-BDE9389246CA@news.elevatesoft.com...
> Tim
>
> I typed
>
> CREATE INDEX IF NOT EXISTS "Name" ON "Memory\tmpfile" (_List;_Name);
>
> ie with a ; rather than a ,
>
> The error generated says there's a missing bracket
>
> Roy Lambert

Clive


Correct it may be - misleading it certainly is

Took me ages trying to find the missing ) and it wasn't until I tried in DBSys I figured out what was wrong

Roy Lambert

Roy,

<< I typed

CREATE INDEX IF NOT EXISTS "Name" ON "Memory\tmpfile" (_List;_Name);

ie with a ; rather than a ,

The error generated says there's a missing bracket >>

Actually, it says that the right parentheses is missing, which is correct -
the semicolon is a statement termination character, hence it thinks that it
has reached the end of the statement without a closing parentheses for the
columns list.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

OK I' defeated I forgot ; was the end of statement character. I wonder why Borland decided to have ; separated index field names? Answers on the back (or front) of used £20 notes to me please!


Roy Lambert