Andreas; would it be possible, if the join was displayed in a grid, to edit
the CALLER info, or to even insert a new caller into the CALLER table from
within the grid, instead of having to do this from another place of input?

Regards,
Dion

----- Original Message -----
From: "Andreas Pohl" <apohl@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 27, 2001 8:41 PM
Subject: Re: [IBO] Editing a JOIN


> Lester,
>
> I think missing Comma between two inline selects is a typo only.
>
> Anyway, if you use your column A in OrderingItmen as number (in your case
4)
> ordering should work.
>
> If you use same inline selects for your where clause instead of A then
> searching should working, too (at least to me, cause I use this contruct
> very often).
>
> Mit freundlichem Gruss & Best Regards
>
> Andreas Pohl
> apohl@...
> www.ibp-consult.com
> ----- Original Message -----
> From: "Lester Caine" <lester@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, September 27, 2001 7:04 PM
> Subject: [IBO] Editing a JOIN
>
>
> > I am getting in a knot and could do with some help.
> >
> > I have a form using two tables, TICKET and CALLER.
> >
> > These used a
> > SELECT T.X, T.Y, T.Z,
> > ( SELECT A FROM CALLER WHERE T.Z = Z ) AS A
> > ( SELECT B FROM CALLER WHERE T.Z = Z ) AS B
> > FROM TICKET T
> > WHERE T.X BETWEEN :A AND :A+1
> >
> > and I can edit using RequestLive
> >
> > but I can't search or order on A.
> >
> > If I change to
> >
> > SELECT T.X, T.Y, T.Z,
> > C.A, C.B
> > FROM TICKET T
> > JOIN CALLER ON T.Z = C.Z
> > WHERE T.X BETWEEN :A AND :A+1
> >
> > I can search and order on A but I can't edit.
> >
> > What should I be doing to get all three working?
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>