I just tried it in RBGX (not enterprise) and like Dan got the "too many rows returned" but it did populate my variable correctly.
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Jun 28, 2016 3:25 pm Subject: RE: [RBASE-L] - ERROR 2038 Referencing Existing Table(s) 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 [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.
