Hi I was not able to follow my own thread as my land line telephone was down so internet was also not there. I went to the client's place. There cant be anything wrong with the view as such as the app has been working for the last four years or so. The parent table had about 60,000 records where as the child had about 192,000 records which is not much at all. So I made two databases for data before year 2007 and one for the current year.
What I have doen is befor the 'Save' I take a count of the no. of records in the child view. 'Save' and then do a requery to see if the same no. of records have come in the child view again else raise an error to check for data not been saved. I have had no complaints for the last three days but the problem which was there also did not happen everyday. So lests see with fingers closed. I have a SQL server query also which I will take up in anothe thread. Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" ----- Original Message ----- From: "MB Software Solutions" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2007 6:49 PM Subject: Re: VFP6 SP5 data not been updated from view > Ajoy Khaund wrote: >> Hi All >> I have an app in a pathologhy laboratory. In the reception the first data >> entry takes place. >> >> Two tables Parent and Child. I am using views for both tables. >> >> Data is entered from one form to the Parent and Child. The Data shows as >> saved successfully and even prints a chits with the data entered(done >> from >> the view). >> >> Since there is a mad rush in the morning the form never shows any error >> but >> the app in its fourth year now sometimes does not save the data generally >> in >> the child table. By the time they realize it a lot of data entry has >> taken >> place. >> >> Now what I need is: >> >> 1. How can I warn them at the earliest that data has not been entered >> into >> the main Child table or Parent Table. >> 2. What sort of solution can I give them. >> >> TIA >> >> Bobby >> > > Make sure you use primary keys. When you create the new parent record, > make sure you get the newly created PK, and then make sure that PK is > stored in the child tables as a foreign key (FK). Is TABLEUPDATE() > returning .T. and are you using the lForce parameter set to .T. ? > > -- > Michael J. Babcock, MCP > MB Software Solutions, LLC > http://mbsoftwaresolutions.com > http://fabmate.com > "Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
