object pointers, joins and order by

[Danny Lewkin]

Feature Request : http://valentina-db.com/bt/view.php?id=2675

Ok, tomorrow is fine by me ;-))



Op 27-sep-07, om 11:55 heeft Ivan Smahin het volgende geschreven:

> Hello Danny,
>
> Thursday, September 27, 2007, 12:32:56 PM, you wrote:
>
>> Hi List,
>
>> This query runs fine :
>
>> SELECT tbl_compcards.competence_descr, tbl_compcards.competence_name
>> FROM tbl_compcards INNER JOIN mm_compcards_course_module ON
>> mm_compcards_course_module.objptr_compcard = tbl_compcards.RecID
>> WHERE objptr_project = 1 ORDER BY tbl_compcards.competence_name;
>
>> But since I have an objectpointer 'objptr_compcard' in the table
>> 'mm_compcards_course_module', pointing to 'tbl_compcards', I would
>> have liked to write the query using that objectpointer. So the query
>> would be like this:
>
>> SELECT objptr_compcard->competence_name, objptr_compcard-
>>> competence_descr FROM mm_compcards_course_module WHERE
>> objptr_project=1 ORDER BY objptr_compcard->competence_name;
>
>> So, I get an error message, telling me that I can not do an ORDER BY
>> on objectpointers.
>
> Actually  you've  got  a  message  'Order  by  pointed  field  is  not
> supported'.
>
>> Why is this? I want to go the valentina-way ALL tha way, but feel
>> restricted now. Is there a workaround except using inner joins? Is it
>> usefull to put a featrue request into mantis for this, or will it
>> never be possible??
>
> Yes, put a request please.
> Certainly, it will be possible some time.
>
> -- 
> 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