SQL query question

Fri Feb 13 00:39:51 CST 2004

on 2/13/04 12:36 AM, Charles Yeomans at yeomans at desuetude.com wrote:

> The following query results in error 612.
> SELECT M1.matter_name FROM Matters M1, Matters M2 WHERE M1.leftIndex
> BETWEEN M2.leftIndex AND M2.rightIndex AND M2.matter_name='ICI'
> 
> Is such a query not possible in the current version of Valentina?

But where is your link condition Charles?

It seems you have self-recursion yes?
With ObjectPtr this works

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------