App is single user. Fields of Parent 'Orders' table is on the form. The child records are displayed in a view. On 'Add' or 'Edit' to child records a form appears where productid, qty, remarks etc are written & saved. Now sometimes after 'Save' when the form closes the record does not appear in the grid. Since u said data conflict. I did see a small error message once when the user was using. When can such errors occur. Any ideas will hep as this is a very simple form.
Michael asked about whertype ? Any link ??? What should a wheretype generally be ??? Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akha...@hotmail.com Mail: akha...@gmail.com "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -------------------------------------------------- From: "Rick Schummer" <pro...@whitelightcomputing.com> Sent: Thursday, April 02, 2009 10:44 PM To: <profoxt...@leafe.com> Subject: RE: Save fails sometimes Vfp9 Sp1 >>>Since it does not happen always and I cant reproduce it how do I trap the > error and save it to somewhere.<< > > If you cannot reproduce the problem, it likely is a data conflict as I > mentioned, but it could be a different bug. > > I already told you how to determine the problem (check the tableupdate and > use AERROR() to find the reason. Recording the error is up to you. Dump > the > array into a table or something simple like a text file. > > IF TABLEUPDATE() && check the parameters you need to pass for your cursor > * All is well > ELSE > * Not so well > AERROR(laDataError) > LIST MEMO LIKE laDataError TO FILE DataNotSaved.txt > ENDIF > > Bullet proof my code sample as needed for your customer environment. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/886208cd64104f4ba5ce261a8da56...@compaq ** 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.