>i have a database with several tables, i want to re build the indexes by first deleting all the tags or deleting the .cdx and issuing index on command for the fields i want to index but the problem is it gives me an error "Cannot update the cursor" what's wrong? i don't use reindex command because as what i have experienced in foxpro for dos, the .cdx file will become bigger.

There are so many glitches you can run into trying to rebuild indexes on tables in a DBC, that I don't bother trying to come up with code to do this. Use Stonefield Database Toolkit instead (www.stonefield.com) because this will save you hours of frustration.