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.
