Hi,

In Fb 2.1, I typed this in my SQL window:

with browse (custid, company, fn, ln, em, p)
as
(select c.CUSTID,
c.COMPANY_NAME,
c.CONTACT_FIRSTNAME,
c.CONTACT_LASTNAME,
c.CONTACT_EMAIL,
c.CONTACT_PHONE
from CUSTOMERS c
where c.IS_ACTIVE = 'T')
select * from browse

Next, I executed only "select * from browse", which fails with unknown
table error.

Then, I executed the full query and it raises:
Unsupported column type: 0

If I execute the full query completely without raising the error first, it
executes just fine.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com