Alan, Recreate the view using commas between the columnnames and parenthesis around the expression. These are required elements in the syntax and you may get weird results when they are not used. See if that helps.
Dennis McGrath create view vwpacount as select pono, accountno, districtno, trantype, (ctxt(pono+accountno)) as poacct from tranmaster,tranacctid,accounts where tranmaster.tranid=tranacctid.tranid and accounts.acctid=tranacctid.acctid --- Alan Wolfe <[EMAIL PROTECTED]> wrote: > hey everybody, > > i just found something wierd with oterro (not sure which version, its > the one that comes with r:tango 5). > > i created a view like this: > > create view vwpacount > as select pono accountno districtno trantype ctxt(pono+accountno) as > poacct > from tranmaster,tranacctid,accounts > where tranmaster.tranid=tranacctid.tranid > and accounts.acctid=tranacctid.acctid > > and found out that from the R> i could of course say things like: > > sel poacct from vwpacount > > and > > sel distinct(poacct) from vwpacount > > but when doing that through oterro via r:tango it would barf saying > unrecognized column, complaining about poacct. I'm guessing oterro > doesnt like aliases or something. > > the workaround was to say > > sel #5 from vwpacount > > and > > sel distinct(#5) from vwpacount > > just a heads up in case anyone else hits this and doesnt know what to > do (:
