>Hi Naomi... Thanks for the quick reply. I will try to remove the ADDITIVE command. On the development computer where
>I run the program through Foxpro, it works fine... but when I compile it and run it on a client's computer I get the error message.
>
>Do I have to add the Index Tags to the database by using command such as ALTER TABLE... ADD FOREIGN KEY ??? and then validate the database????
>
>
>Raz
It depends on the type of the indexes. If the index is used in the PK/FK relationshipt, then you may need to use ALTER TABLE command. Otherwise INDEX ON command (with or without ADDITIVE) should be fine.
May be after these commands you need to check, if the indexes were really added (you can check with ataginfo function). Also add some error checking to the procedure. May be it silently hit an error and didn't even try to add indexes back.
If it's not broken, fix it until it is.
My Blog