Hi,

I have make a form and include 2 or 3 tables into the data environment. Under the properties of the table in the data environment, I have set the exclusive to be true. But however when I perform a SQL insert command to one of the table and follow by a reindex, it message "table need to be open exclusive". I try to put set exclusive on at the start of the code but same message appear.

If i try to put the statement "use tablename exclusive" before the insert and reindex statement, the message "table is in use" will appear. (I guess is because i have already put the table in the data environment)

Any 1 can help to clear my doubt what is the actual correct way to insert a data into the table and perform a reindex.

Thank you and best regard