>Thanks Sergey. That confirms my thoughts (or fears?).
>
>I was talking to a friend about this the other day and he suggested I create a dummy DBC with a dummy table. In the dummy table I have an update trigger which calls a stored procedure to open a table (along with the non-structural index file), reindex it, and then close it. The dummy table has a column for the name of the table to be reindexed. So, via ODBC, in order to cause a particular table to be reindexed, we just need to send an update command to change the table name column in the dummy table (the table has only 1 record). This fires the trigger which then goes off and reindexes the specified table. A similar approach could be used to cause almost any VFP code to be run.
>
>Perhaps this will be helpful to someone.
>
>Twila Miller
You can even pass 'parameters' to the trigger by adding one or more fileds to this table and populate them with info you want to pass into trigger.
--sb--