Binary links and SQL

[Mathieu Langlois]

I have created a report in mantis.  where do I send an example file?

On 7/16/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 7/16/05 4:38 AM, "Mathieu Langlois" <realsoftlists at gmail.com> wrote:
> 
> Hi Mathieu,
> 
> > Can this be used to link several tables?
> 
> Yes should work.
> 
> > For example, I have table M, which is linked to T1 and T2 (but T1 and
> > T2 are not linked together).
> >
> > SELECT * From M
> > join T1 ON LNK_M_T1
> > join T2 ON LNK_M_T2
> >
> > This will give:
> > 21:36:45: Error: Kernel error: 529669
> > 21:36:45: Error: The table "T1" is not used in link "LNK_M_T2".
> 
> Please send database prototype to us. And add report into Mantis.
> 
> Before this try next:
> 
> SELECT *
> >From (M join T1 ON LNK_M_T1)
>         join T2 ON LNK_M_T2
> 
> 
> > Normally this should return all fields from M + all linked fields from
> > T1 and T2.
> >
> > Math
> >
> > On 6/20/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> >> On 6/20/05 4:54 PM, "Mathieu Langlois" <realsoftlists at gmail.com> wrote:
> >>
> >> Hi Mathieu,
> >>
> >>> Hello, I have been evaluating the demo of valentina for Realbasic, and
> >>> I have one question.  Is there a way to use binary links on a SQL
> >>> Join?
> >>
> >> Yes of course!
> >>
> >>> With foreign keys, you have something like JOIN Table ON key =
> >>> ptr, but what syntax (if any) can be used for binary links?
> >>
> >> SELECT
> >> FROM T1 join T2 on link_name
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>