Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't open table exclusive
Message
From
13/08/1999 15:29:48
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00253394
Message ID:
00253624
Views:
26
Yup, the problem comes back when I open the tables in the other order.
I think I finally figured out what it was though. After opening each table, I was deleting records. Turns out there was an old delete trigger on the parent table to mytable. In the original order of opening the tables, this parent table was opened first. When I deleted a record, it fired the delete trigger, which opened the child table mytable. Then, even though it closed the child table, when I went to open it, it somehow thought is was already opened (I think) and so opened it shared. So, when I changed the order, the child table got opened first, so when the parent's delete trigger fired, mytable was already opened exclusive. Anyway, I removed the delete trigger, and now everything works fine in the original order.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform