>I need to change and index expression from a table from the default (field name) to VAL(fieldname). I can do this easily in the Project Manager, but I need to do this on an installed site using commands in an update program.
>
>I thought I would use an ALTER TABLE command but do I need to DROP the FOREIGN key first (it's a 'regular' key) and then ADD the new key? What would the commands be>
>
>
>Thanks
Since it is a regular key, there is nothing to drop, open the table exclusively and issue the command:
INDEX ON VAL(fieldname) TAG tagname
Mark McCasland
Midlothian, TX USA