I've done the disabling of an object and it does work. However I'm always providing feedback such as a PAUSE that you clear after the processing is completed. -----Original Message----- From: Albert Berry <[email protected]> To: "[email protected]" <[email protected]> Date: Tue, 18 Jul 2017 13:44:46 -0600 Subject: Re: [RBASE-L] - clicking too often
Temporary tables are not within the database, they are .$$$ files on the drive. I always drop and never delete from temporary tables with no problems. The problems here appear from the posts to be that a second (double) click is sending a second request to the system. There is one post in here that suggests that the first click can be used to disable the component so that R:Base doesn’t see the second click. I have not tried that myself, but it certainly sounds like a reasonable idea. On Jul 18, 2017, at 1:06 PM, Tony IJntema <[email protected] [mailto:[email protected]]> wrote: James, Maybe a silly question, but why dropping the table instead of emptying the table. It looks a less vulnerable operation to me, but I could be wrong. Tony Van:[email protected] [mailto:[email protected]][mailto:[email protected] [mailto:[email protected]]]NamensJim Belisle Verzonden:dinsdag 18 juli 2017 18:18 Aan:[email protected] [mailto:[email protected]] Onderwerp:RE: [RBASE-L] - clicking too often Dan, That may explain what has been happening. A particular employee, twice now, has corrupted the DB. Each time he gets an error that the temp table is not available. If he is double clicking, could it be the second click is so fast it is running the deleting of the temp table (I delete temp tables at the start per training)? Then the computer is confused? Not sure but so far it is only the one employee. I am not on site until next week so I am not sure if this is the case. But it is strange that it is the same employee each time. SO he must be doing something and as the programmer I need to stop him. James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> From:[email protected] [mailto:[email protected]][mailto:[email protected] [mailto:[email protected]]]On Behalf OfDan Goldberg Sent:Tuesday, July 18, 2017 11:13 AM To:[email protected] [mailto:[email protected]] Subject:RE: [RBASE-L] - clicking too often That is correct jim Dan Goldberg Lance Camper On Tue, Jul 18, 2017 at 9:09 AM -0700, "Jim Belisle" <[email protected] [mailto:[email protected]]> wrote: Dan and Jan, So this is a bit button. It creates a temp table then has code verifying the employee information prior to bringing up another form. You are saying I should put the property command at the start of the code. Then if the employee double clicks instead of clicking, this will prevent the code from repeating. Then Enable to form bit button at the end of the code. Is this correct? James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> From:[email protected] [mailto:[email protected]][mailto:[email protected] [mailto:[email protected]]]On Behalf Ofjan johansen Sent:Tuesday, July 18, 2017 10:55 AM To:[email protected] [mailto:[email protected]] Subject:Re: [RBASE-L] - clicking too often One thing you can do is "disable" the object in the on-click eep., Like PROPERTY VariableListViewObject ENABLE FALSE -----Original Message----- From: Jim Belisle <[email protected] [mailto:[email protected]]> To: "[email protected] [mailto:[email protected]]"; <[email protected] [mailto:[email protected]]> Date: Tue, 18 Jul 2017 15:50:14 +0000 Subject: [RBASE-L] - clicking too often In the past there was a thread about preventing more than one click because of users being so used to “double clicking”. I have looked in my saved lists and cannot seem to find it. Can anyone give me an idea of how to prevent this? We just installed my shop management system out in the shop and am concerned the employees will do the double clicking. I want my code to be a “security blanket” against corruption due to too many clicks. James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected] [mailto:[email protected]]. For more options, visithttps://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected] [mailto:[email protected]]. For more options, visithttps://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected] [mailto:[email protected]]. For more options, visithttps://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected] [mailto:[email protected]]. For more options, visithttps://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
