How to change index programmatically

[Chlaris]

Dear all,

I have existing primary key index which consists of field A + field B.
Now I want to modify the index which consists of field A + field B + field
C.
How to change it programmatically ?
Thanks.

Chlaris

 

[Alex Dybenko]

Hi,
you have to delete existing key and then create a new one. You can do this
either using DAO (see CreateIndex Method), or DDL (see ALTER TABLE
Statement)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com