views

[Danny Lewkin]

Hey Ivan,

I don't need them! ;-))
I was just wondering, since I querried a RecID from a table, if I was  
given that RecID, or if it was a RecID of the view.... And if I could  
use a column name 'RecID' in a view...
Just wanted to be sure, that's all...
So, it's perfect for me like it is now...

Thanks,

Danny


Op 6-aug-07, om 11:32 heeft Ivan Smahin het volgende geschreven:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina