Thanks Razzak. I missed the "session specific" in my response! Regards Lena
-----Original Message----- From: [email protected] <[email protected]> On Behalf Of A. Razzak Memon Sent: Thursday, May 03, 2018 4:52 PM To: [email protected] Subject: RE: [RBASE-L] - Does Table exist? Lena, FYI, TEMPORARY tables/views are "session specific" tables/views, meaning, each session of R:BASE retains and maintains its own TEMPORARY table(s)/view(s). Yes, your understanding of "Temp tables are unique/mutually exclusive for each user" or session is correct! Temporary tables/views created by user Lena will NOT be seen by another user, or even a separate session of R:BASE started by Lena. Hope that helps! Very Best R:egards, Razzak At 05:31 PM 5/3/2018, Lena Dammstrom wrote: >Someone can correct me if I am wrong, but I have it in my head that >Temp tables are unique/mutually exclusive for each user. > >I.e. TempTableA created by user Lena cannot be seen/used by user Doug >and vice-versa So the same program called by Lena could create >TempTableA and same program called by Doug would also TempTableA > >Regards >Lena > >From: [email protected] ><[email protected]> On Behalf Of Doug Hamilton >Sent: Thursday, May 03, 2018 3:03 PM >To: R:Base List <[email protected]> >Subject: Re: [RBASE-L] - Does Table exist? > >Thanks Lena, Razzak and Buddy. >The temp table is in an item maintenance routine. I don't want to >delete it if there are other parts being edited by the same user. >I was going to create a unique temp table for each part, but that got >ugly real fast. > >Doug > >On 5/1/2018 11:04 AM, Buddy Walker wrote: > >I think doing a COUNT(*) FROM SYS_TABLES is the best way to check for >an existing table. With that being said and you truly want to >delete/drop a TEMPORARY table then recreate it I would just turn the >error message off and drop the table then turn the error message back >on. > > SET ERROR MESSAGE 2038 OFF > DROP myTempTblName > SET ERR0R MESSAGE 2038 ON > CREATE TEMPORARY myTempTblName ……… >/p> >Buddy > > >From: ><mailto:[email protected]>[email protected] ><mailto:[email protected]><[email protected]> >On Behalf Of Lena Dammstrom >Sent: Tuesday, May 1, 2018 11:41 AM >To: <mailto:[email protected]>[email protected] >Subject: RE: [RBASE-L] - Does Table exist? > >Doug, I be interested in a more elegant way of checking for the >existence of a table too! > >I use the count method: >SET VAR vCount = 0 >SELECT COUNT(*) INTO vCount FROM Sys_Tables + > WHERE Sys_Table_Name = 'TableName' AND LIMIT = 1 > > >Regards >Lena >From: ><mailto:[email protected]>[email protected] ><<mailto:[email protected]>[email protected]> >On Behalf Of Doug Hamilton >Sent: Tuesday, May 01, 2018 10:33 AM >To: R:Base List ><<mailto:[email protected]>[email protected]> >Subject: [RBASE-L] - Does Table exist? > >I'm drawing a blank - is there a >command/function (in 9.5) to check for the existence of a table? >I want to see if a temp table exists before I try to recreate it. > >I could try to count rows and check for error messages if the table >isn't there but I suspect there's a more elegant method. >'Course, recreating an existing table would also give an error message... > >TIA, >Doug >Now to get more coffee.... > ><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c >ampaign=sig-email&utm_content=emailclient&utm_term=icon> >Image removed by sender. > >Virus-free. ><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c >ampaign=sig-email&utm_content=emailclient&utm_term=link>www.avast.com > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas >e.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 ><mailto:[email protected]>[email protected]. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas >e.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 ><mailto:[email protected]>[email protected]. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas >e.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 ><mailto:[email protected]>[email protected]. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas >e.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 ><mailto:[email protected]>[email protected]. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas >e.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 ><mailto:[email protected]>[email protected]. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout. -- 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]. For more options, visit https://groups.google.com/d/optout.
