1,2 and 4 didnt help but #3 did in fact work and it lets me use poacct. Interesting!
----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, November 03, 2003 2:24 PM Subject: [RBASE-L] - Re: oterro > Alan, > > A couple ideas: > > 1) You broke syntax rules in your CREATE VIEW statement by not using > commas between items. That may have helped mess up the parsing for > the aliasing. > > 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 > > 2) Your expression for poacctno broke syntax rules by not being > surrounded with parentheses: > > 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 > > 3) There is another way to name columns in CREATE VIEW that may help. > > 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 > > 4) And, if you are trying to use a search action, and not a direct DBMS, you > can use a "custom column" in Witango, and surround it with IDQUOTES > characters. > > `vwpacount.poacct` > > Bill > > On Mon, 3 Nov 2003 14:07:15 -0800, Alan Wolfe wrote: > > >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. >
