[RBASE-L] - oterro

Mon, 03 Nov 2003 15:09:53 -0800

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 (:

Reply via email to