Hi Doug, What Tony says. The Temp Tables are deleted automatically when the session is closed anyway and row deletion is not problematic anyway.
On Saturday, May 27, 2023 at 3:09:35 AM UTC-4 Tony IJntema wrote: > Hi, > > Though it is maybe not the expected answer to your question, it could be a > solution for your problem. > > What you can do is create the temp table once and then only delete all the > rows when you start the procedure. > > Tony > > > Op 27-05-2023 om 05:35 schreef Doug Hamilton: > > I create a temporary table in a form's On Before Start EEP > The form is run dozens of times a day. > Once or twice a week I trap an SQL 2440 error, "Unavailable resource > encountered during <command> command". > This is not machine-specific, it occurs on several computers. > SCRATCH is set to TMP - local C:\Users\...\Temp > WAIT TIME is 15 seconds. > INTERVAL is .5 seconds. > > What could be causing the error message? What resource could be > unavailable? > Or is it a red herring message and it's really something else? > > Code is below. > The [error routine] allows up to 4 tries to loop back and create the > table. > It usually works the second time; once in a great while it fails after 4 > tries and I exit the program. > > TIA & Happy Memorial Day weekend - take a moment to reflect. > Doug > > SET ERROR MESSAGE 2038 OFF > DROP TABLE tSHPT > SET ERROR MESSAGE 2038 ON > > CREATE TEMPORARY TABLE `tSHPT` + > (`PIKD_ID` INTEGER, + > etc ) > > SET VAR vSQLCode = .SQLCODE > IF vSQLCode <> 0 THEN > [error routine] > ENDI > > -- 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/82e48283-255e-4dba-8864-6ff43e77097en%40googlegroups.com.
