object pointers, joins and order by

[Ivan Smahin]

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