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]> 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]>] Namens > Jim 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 > Of Dan 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 > Of jan 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 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] > <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] > <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] > <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.
