How to change the index collating ?

[stvhui]

Hello to you,
I'm uisng vfp7

How to change the index file collating ?

I'd a free table named "table1"
contains : 2 index tag (tag1 & tag2)

I ussuing in command window :
use table1
disp status

The information displayed and it show the collating is "machine".

The problem is I want to change to "general", How ?

It's just delete the index file and set collate to "general"
then re-create index.

Please advice
Steven

 

[ChrisRChamberlain]

stvhui

USE table1 IN 0
SET ORDER TO TAG general HTH

Chris

 

[stvhui]

USE table1 IN 0
SET ORDER TO TAG general

Are you sure ?
I don't think your understand my questions

 

[ChrisRChamberlain]

stvhui

I understood your question to be :-

How do I change the index tag?

Are you asking how you index on a general field?

If so, the answer is you can't - you would need another field that relates to the contents of the general field and index on that. HTH

Chris

 

[Mike Gagnon]

Try :

SET COLLATE TO GENERAL
SELECT myTable
INDEX ON field1 TAG tag1
SET COLLATE TO

 

[Mike Gagnon]

Sorry the above should read:
SET COLLATE TO "GENERAL"
SELECT myTable
INDEX ON field1 TAG tag1
SET COLLATE TO

 

[danceman]

mgagnon is correct, I think the others misunderstood your question.

SET COLLATE TO "GENERAL"
SELECT myTable
INDEX ON field1 TAG tag1
SET COLLATE TO
Attitude is Everything