>>>>>>In my cleanup method I call CLOSE ALL. When I do that I get an Update Conflict error. How do I find out which table is causeing this problem so I can fix it?
>>>>>
>>>>>Are you using a view? If yes, make sure you don't have any primary key conflict.
>>>>
>>>>Yes, I'm using a couple of views. How do I check for a Primary key conflict?
>>>
>>>I would suggest to open the table manually and do a SQL group by to see if you have a key which has more than one occurence.
>>
>>Mike,
>>
>>I've tried that and everything seems OK. The error doesn't happen everytime I quit the program, so it is hard to catch.
>>
>>Ed
>
>Instead CLOSE ALL, you could close table/views one by one with appropriate error trapping for each USE command. At least here you will catch the alias.
Good suggestion. Ed
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement