23.08.2012 17:52, Adriano dos Santos Fernandes wrote:
> But maybe we can return NULL for views of more than one table and
> maintain it as a number? At first, I'm more for that.

   No, it must return version from real table record. Like this:

create view v (a,b) as select t1.rdb$record_version, t2.rdb$record_version
  from t1,t2

   If the name is used without table alias in multitable select, it should 
return usual 
error "Ambiguous column reference", IMHO.

-- 
   WBR, SD.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to