Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Tue, Sep 1 2009 5:57 AM	Permanent Link
Chris Holland SEC Solutions Ltd. Team Elevate	How can I refine an index that already exists to be a UNIQUE index using SQL in DBISAM Version 4? I have tried the following: ALTER TABLE CostingHeader REDEFINE NameIndex UNIQUE NOCASE Name Where NameIndex is the name of the index and Name is the column, but it objects to the UNIQUE and/OR NOCASE statements. Chris Holland
Tue, Sep 1 2009 7:17 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Chris try DROP INDEX followed by CREATE INDEX Roy Lambert [Team Elevate]
Tue, Sep 1 2009 9:35 AM	Permanent Link
"Rita"	"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:DFF986AC-330A-4DB2-B6F0-F7AE47BD5859@news.elevatesoft.com... > Chris > > try DROP INDEX followed by CREATE INDEX > Nice one Roy you tell that C programmer how to do it. Rita
Wed, Sep 2 2009 2:41 AM	Permanent Link
Chris Holland SEC Solutions Ltd. Team Elevate	Thats a C# programmer now Chris Rita wrote: > "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message > news:DFF986AC-330A-4DB2-B6F0-F7AE47BD5859@news.elevatesoft.com... >> Chris >> >> try DROP INDEX followed by CREATE INDEX >> > > Nice one Roy you tell that C programmer how to do it. > Rita > >
Wed, Sep 2 2009 9:41 AM	Permanent Link
"Rita"	"Chris Holland" <mail@chrisholland.me.uk> wrote in message news:5D780031-952C-4937-9903-92EC61EA5BD7@news.elevatesoft.com... > Thats a C# programmer now > I think Mr. Young must have been a C guy at onetime. After having the source for CS all these years I just got around to looking at it, I got sidetracked so many times I thought it was written by Kerringham & Ritchie Rita