I find that sometimes rbase does not like you to use the same column name as an autonumbered or computed column in another table. I usually use another column name like putting a "t" prefix.
Dan Goldberg From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Friday, June 2, 2023 7:30 AM To: [email protected] Subject: [EXTERNAL] Re: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes I sent this on 5/30 but it didn't go through. My apologies if it's a duplicate. Clarifications on create temp table based on responses received: Main Menu is RFF, db is disconnected. Main Menu item is clicked, db gets connected, the form starts and runs OBS EEP to create temp table. At this point, no temp tables exist because the db has been disconnected for this user; so there can't any open cursors on the temp table that's going to be created. Create temp table code is from permanent table definition with "TEMPORARY" added; the first column, PIKD_ID, exists in another table - it has same column name and datatype. If another user had created a temp table, wouldn't that table and its columns be invisible to this user? And a table, temp or permanent, can't be created with common column name and different datatype. No user would have form designer open, I can do enough damage on my own :) Hmm, good point though - I do form development on my system and unload the form, then load it into client's system. Client's designers are rarely used. Thanks for the responses and making me think this through a little more. Doug Karen: Packers/Bears - Yeah, what a way to start/end the season. Packers are gonna be in "rebuild" mode for a few seasons. On 5/27/2023 7:35 AM, 'Karen Tellef' via RBASE-L wrote: So from your code I'm assuming it is the CREATE that isn't working, not the drop. I've seen that error message when trying to drop a table and there is a "declare cursor" still defined on a temp table that was never dropped. There's only one thing I can think of with the Create, and that's whether some other program is creating a temp table with a common column name but with a different data type. But that wouldn't explain why the loop sometimes works. And I'm guessing that no one would have the form or report designer up that uses the temp table? Hey, did you see that Packers / Bears schedule??? Karen -----Original Message----- From: Doug Hamilton <[email protected]><mailto:[email protected]> To: R:Base List <[email protected]><mailto:[email protected]> Sent: Fri, May 26, 2023 10:35 pm Subject: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes 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 -- This email has been checked for viruses by Avast antivirus software. www.avast.com<http://www.avast.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/83ca8547-99bc-0b03-214f-f3de6216bc8e%40wi.rr.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/868214035.2618807.1685190929466%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/868214035.2618807.1685190929466%40mail.yahoo.com?utm_medium=email&utm_source=footer>. [https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free.www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> -- 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/6c741e6b-0182-5e93-e788-c32f5d5b7e09%40wi.rr.com<https://groups.google.com/d/msgid/rbase-l/6c741e6b-0182-5e93-e788-c32f5d5b7e09%40wi.rr.com?utm_medium=email&utm_source=footer>. -- 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/BY3PR19MB502756D64602A3A433C46A9AD44EA%40BY3PR19MB5027.namprd19.prod.outlook.com.
