Querying linked tables using SQL

[Ruslan Zasukhin]

On 31/3/07 8:35 PM, "Charles Yeomans" <charles at declareSub.com> wrote:

Hi Charles,

> The following query used to work for me, but stopped doing so
> sometime around V4Rb 2.5.
> 
> SELECT Decisions.recID FROM Decisions JOIN Law ON LawDecision WHERE
> Decisions.is_deleted=false AND (Law.recID=36)
> 
> Here, LawDecision is a M-M link between the tables Law and Decision.
> 
> VStudio shows linked records as they should be, at least for a local
> database; 

You mean in data browser?

> as usual, the same thing for a remote database does not
> work.  So I don't think that it is a database corruption issue --
> any other suggestions?

I have not catch.

1) so query works LOCALLY ?

2) and not works on vserver?
    I doubt. Because this is the same engine AND SQL.

3) LawDecision is BinaryLink, right?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]