Thanks. That's what I did and finally found the problem. A candidate index was being violated!
The help file is not very helpful when it comes to using AERROR() but I got it to work in the end. It is early evening here and I was anxious to post my problem before everyone went for the usual Friday beer!!! Thanks again - once more Profox to the rescue (and VRunFox which helped the client clear the problem) John Weller Wessex Computer Solutions 01380 728880 07976 393631 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Richard Kaye > Sent: 13 October 2006 17:51 > To: [EMAIL PROTECTED] > Subject: Re: Tableupdate Issue - HELP!!! > > > Load up AERROR() immediately after the update fails and you will get an > array that will give you the reason the update is failing. > > AERROR(laError) > DSIPLAY MEMORY LIKE laerror* > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
