views

[Ivan Smahin]

Hello Danny,

Monday, August 6, 2007, 12:01:41 PM, you wrote:

> Hey Ruslan,

> am I right when I say that records of a view don't have a RecID?
Yes, correct.

> I created a view

> CREATE OR REPLACE VIEW vw_project_languages AS
> SELECT mm_project_languages.RecID,  
> mm_project_languages.project_displayname,  
> tbl_input_languages.language_name
> FROM tbl_input_languages INNER JOIN mm_project_languages ON  
> mm_project_languages.objptr_language_id = tbl_input_languages.RecID;

> When I query this view like this 'SELECT ** FROM  
> vw_project_languages" then I don't have a RecID-column (except the  
> one I requested for in the view-select-statement), and no OID-column?

I would say that "view" could be considered as "virtual table" as
first approach only. In deep it is "named query".
So  you  can not expect to get any extra fields - their are matter of
"material"  tables  only.  The  only  fields  defined  in the view are
available to be selected in the outer query.

BTW, why do you need to get view's RecID?


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com