Thanks, Jan. That was my next step. I even had the code there to implement.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, February 27, 2020 7:13 PM To: [email protected] Subject: Re: [RBASE-L] - TWO INSERTS I think I’d put a PAUSE FOR 1 In between the inserts. Make sure that you have a DIALOG before inserts to let the user know something is happening and CLS after the inserts. > From: Jim Belisle <[email protected]><mailto:[email protected]%3e> > To: "[email protected]<mailto:[email protected]>" > <[email protected]><mailto:[email protected]%3e> > Date: Thu, 27 Feb 2020 20:24:29 +0000 > Subject: [RBASE-L] - TWO INSERTS > I have a few places in my code where I do two inserts into two > different tables one right after the other. > Most of the time that is not a problem. > However there is code that runs on the thin clients out in the shop > (hardwire) where recently the second table does not get populated as it > should. > Once again this is only once in awhile. > The code runs in an on exit (from a field) EEP. > The information going into both tables is from a view. > > First insert > INSERT INTO inventry + > (list of columns) + > SELECT list of columns + > FROM twkinvtbl > > Second insert > > INSERT INTO workdetail + > (list of columns) + > SELECT list of columns + > FROM twkinvtbl > > He form closes after dropping the temp view. > Any BLUES CLUES? > > (Also this field is populated by scanning a location. All they user is > supposed to do after the scan is hit the enter key.) > > James Belisle > > Making Information Systems People Friendly Since 1990 > [cid:[email protected]<mailto:cid:[email protected]>] > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > 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]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CH2PR02MB704775C028C7BDA18663 > 88B6A0EB0%40CH2PR02MB7047.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20200228011310.570029%40jjcalibrations.com. ________________________________ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70477B0C37AB353A80921464A0E80%40CH2PR02MB7047.namprd02.prod.outlook.com.
