I hadn't thought of that, but just tried and got the same results. ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, November 03, 2003 2:11 PM Subject: [RBASE-L] - Re: oterro
> 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 (: >
