Okay, let's see... So I just now tested your second select command on my RBGX database and it worked fine.
Here's the syntax that worked for me: SELECT (LISTOF(#1)) INTO vText iv1 FROM Sys_Columns t1, Sys_Tables t2 WHERE t1.Sys_Table_ID = t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol" This did NOT work (got "syntax is incorrect for select"): SELECT (LISTOF(#1)) INTO vLOJoin_Column_LIST IND iv1 FROM Sys_Columns t1, Sys_Tables t2 WHERE t1.Sys_Table_ID = t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol" Only difference is the variable name... Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Jun 28, 2016 3:55 pm Subject: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s) Dan/Karen: Hmm, indeed. Adding "AND LIMIT = 1" to the first block solves the problem for that block: --JOINER Column Name SELECT #1 INTO vWalk_JLINK_COLUMN INDICATOR iv1 + FROM Sys_Columns t1 , + Sys_Tables t2 + WHERE t1.Sys_Table_ID = t2.Sys_Table_ID + AND t2.Sys_Table_Name = .vWalk_JLINK_TABLE + AND LIMIT = 1 That is NOT the solution for the second block, as I need a list of column names returned: --Capture Column Names for LOJoin_ColumnSET Assembly SELECT (LISTOF(#1)) + INTO vLOJoin_Column_LIST INDICATOR iv1 + FROM Sys_Columns t1, + Sys_Tables t2 + WHERE t1.Sys_Table_ID = t2.Sys_Table_ID + AND t2.Sys_Table_Name = .vLoop101_TABLE ... adding "AND LIMIT = 1" returns only the first column name. Do I first need to do a column count and then set the limit to that? Or is this not the way to snag a list of column names for a table? Thanks for helping. Bruce ------ Original Message ------ Sent: 6/28/2016 1:25:49 PM Subject: RE: [RBASE-L] - ERROR 2038 Referencing Existing Table(s) From: "Dan Goldberg" <[email protected]> To: "[email protected]" <[email protected]> Cc: Hmm when I run it in 9.5 it says “too many rows returned”, which would make sense since most tables have more than one row? Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Tuesday, June 28, 2016 11:06 AM To: [email protected] Subject: [RBASE-L] - ERROR 2038 Referencing Existing Table(s) RBGXE v. 0526 or 0627 Can anyone suggest why an Error #2038 ( -ERROR- #21 is an unidentified table.) ... is thrown by the following code? --JOINER Column Name SELECT #1 INTO vWalk_JLINK_COLUMN INDICATOR iv1 + FROM Sys_Columns t1 , + Sys_Tables t2 + WHERE t1.Sys_Table_ID = t2.Sys_Table_ID + AND t2.Sys_Table_Name = .vWalk_JLINK_TABLE TRACE confirms that the temp table referenced in variable vWalk_JLINK_TABLE exists at the time this code runs. BROWSE confirms that the data is correct. TRACE confirms that the output variable vWalk_JLINK_COLUMN has been populated with the correct value before the error is thrown. The same dynamic occurs with a subsequent block: --Capture Column Names for LOJoin_ColumnSET Assembly SELECT (LISTOF(#1)) + INTO vLOJoin_Column_LIST INDICATOR iv1 + FROM Sys_Columns t1, + Sys_Tables t2 + WHERE t1.Sys_Table_ID = t2.Sys_Table_ID + AND t2.Sys_Table_Name = .vLoop101_TABLE The referenced table exists prior, and the columnname list is captured into the output variable. Several blocks of identical code - varying only in their variable assignments - work without issue, before AND after each of these. This is in code which has worked without modification for over a year. Thoughts? Bruce Chitiea SafeSectors, Inc. 909.238.9012 Mobile -- 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. -- 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. -- 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. -- 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.
