All: Best reviewed in monospaced font
RBase xTreme 9.1(64) 9.1.5.20816 RCharts 9.1(64) 9.1.5.20410 Single User Licenses R:Charts throws the error message: "Column or variable vassnid not found (2515)" ... when drawing upon a source view where 'vassnid' is the first variable referenced within the sole sub-select statement. In a 'non-variablized' test setup, the view successfully feeds the chart. Because of my single-user environment, the source database is disconnected while running RCharts, though all global variables used in view creation exist and are current within the RBase environment (listed below. normally I would clear them at the end of the routine, but I've left them un-cleared for troubleshooting) Any thoughts? Bruce VIEW CODE: CREATE VIEW vwAssnRangeDepositDetail + (fyid,fymid,fyyrnum,cmyrnum,cmyrabbr,depdate,dtid,depamt,sortorder) AS + SELECT + t1.fyid, + t3.fymid, + t2.fyyrnum, + t4.cmyrnum, + t4.cmyrabbr, + t3.depdate, + t3.dtid, + t3.depamt, + t5.sortorder + FROM + zfyear t1, + fymonth t2, + deposit t3, + zcalmonth t4, + zdeptype t5 + WHERE + t3.fymid BETWEEN .vbegrangefymid AND .vendrangefymid AND + t2.fymid = t3.fymid AND + t1.fyid = t2.fyid AND + t4.cmid = t2.cmid AND + t5.dtid = t3.dtid AND + t3.fiaid IN + (SELECT fiaid + FROM deposit t1, fiacct t2, fi2assn t3 + WHERE t3.assnid = .vassnid AND + t2.fi2aid = t3.fi2aid AND + t1.fiaid = t2.fiaid) + ORDER BY t3.depdate,t5.sortorder GLOBAL VARIABLES: Variable = Value Type ------------------------- ------------------------------ ------- #DATE = 08/16/2012 DATE #TIME = 16:43 TIME #PI = 3.14159265358979 DOUBLE SQLCODE = 0 INTEGER SQLSTATE = 00000 TEXT #NOW = 08/16/2012 16:43 DATETIME gvbackupfilepath = D:\active\rbase\data\0-code\ TEXT gvdatadrv = D: TEXT gvcurrdrv = D: TEXT gvdbdir = HUMPTY TEXT vassnidchosen = 10001 TEXT vassnid = 10001 INTEGER vbegdpdday = 25 INTEGER vmincmyear = 1980 INTEGER vmaxcmyear = 2030 INTEGER vmindepdate = 10/03/2004 DATE vmaxdepdate = 07/31/2012 DATE v1stdepcmyrnum = 2004-10 TEXT v1stdepcmid = 10298 INTEGER v1stdepcmyrabbr = 2004-OCT TEXT vnthdepcmyrnum = 2012-07 TEXT vnthdepcmid = 10391 INTEGER vnthdepcmyrabbr = 2012-JUL TEXT vbegrangeabbr = 2011-JUL TEXT vbegrangenum = 2011-07 TEXT vbegrangecmid = 10379 INTEGER vbegrangefymid = 10373 INTEGER vendrangeabbr = 2012-JUL TEXT vendrangenum = 2012-07 TEXT vendrangecmid = 10391 INTEGER vendrangefymid = 10385 INTEGER
