In addition, when using foreign access, you need to provide a specific list of column names. The "as alias" does not carry through.
create view vwpacount + (pono, accountno, districtno, trantype, poacct) + as select pono, accountno, districtno, trantype, (ctxt(pono+accountno))from tranmaster,tranacctid,accounts where tranmaster.tranid=tranacctid.tranid and accounts.acctid=tranacctid.acctid "Alan Wolfe" <[EMAIL PROTECTED]> wrote: >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 (: >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
