Ben, I have never had much luck running with Transaction ON. The Transaction setting is one that has to match amoung all of your users, so in a multi user environment, it is not very practical to just turn it on for a small piece of code. There is a lot of overhead involved with using it. I always write code to deal with these types of transactions and maybee you need to do row by row processing.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 9/17/02 7:00 pm >I am running a particular code with Transaction Set on. What are, it any >the limitations with using the Transactions Set On and does it affect >certain machines? > >Benjamin > >----- Original Message ----- >From: "Tom Grimshaw" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, September 17, 2002 5:53 PM >Subject: Re: A Strange Problem > > >> G'day Ben, >> >> One of the first things I try in this scenario is to SET MESSAGES ON and >> SET ERROR MESSAGES ON. (If this is on a user's machine you can do this >> via a menu option in your application.) >> >> This will sometimes yield an helpful message prior to the one you are >seeing. >> >> As well as that, try opening the form in designer, rather than through the >> application, that will tell you if it is a form corruption. >> >> Are you running in TRANSACTION mode? >> Is this app used on other machines? >> Is this problem specific to this machine? >> Does it occur after an identifiable incident? >> (Crash, power outage etc.) >> Is it always the same user on this machine? >> >> At 16:48 17/09/02 -0400, you wrote: >> >I am running an R:Base 6.5++ application on a Windows 98 computer since >> >January now and never had any problems and suddenly about three weeks ago >> >the system would not pull up two of the forms which were data input forms >> >and the system showed the following message and goes out of the program: >> > >> >"Database is not in need of recovery". >> > >> >I tested the program on another system and could not duplicate the >> >problem. So I then reformatted the hard drive and that corrected the >> >problem for about a week and the computer did the same thing. At this >> >point I installed a new hard drive this work fine for another week and >now >> >I have encountered the same problem. >> > >> >Two of my forms the computer will not access and on one form I get the >> >same message shown above. >> > >> >Are there any suggesstions or thoughts? >> > >> >Benjamin Strickland >> >> Warmest regards, >> >> >> Tom Grimshaw >> coy: Just For You Software >> tel: 612 9552 3311 >> fax: 612 9566 2164 >> mobile: 0414 675 903 >> >> post: PO Box 470 Glebe NSW 2037 Australia >> street: 3/66 Wentworth Park Rd Glebe NSW 2037 >> >> email: [EMAIL PROTECTED] >> web: www.just4usoftware.com.au >> >> "... the control of impulse -- is the first principle of civilization."-- >> Will Durant, >> Pulitzer Prize winning philosopher, writer and historian >> >> the most needed product in the world can be found at >> www.thewaytohappiness.org >> >> This email and any files transmitted with it are confidential to the >> intended recipient and may be privileged. If you have received this email >> inadvertently or you are not the intended recipient, you may not >> disseminate, distribute, copy or in any way rely on it. Further, you >should >> notify the sender immediately and delete the email from your computer. >> Whilst we have taken precautions to alert us to the presence of computer >> viruses, we cannot guarantee that this email and any files transmitted >with >> it are free from such viruses. >> >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: INTRO rbase-l >> ================================================ >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> ================================================ >> TO SEARCH ARCHIVES: >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
