--- In IBObjects@egroups.com, Lucas Franzen <luc@r...> wrote:

>
>
> gsbrown@G... schrieb:
> >
> > I have a TIB_Query component on a form that has the following SQL:
> > SELECT
> > GDATE
> > , GTIME
> > , GLEVEL
> > ,Finger
> > ,GEvent
> > , (select finger.finger
> > from finger
> > where
> > finger.idx_finger = glucose.finger) as luFinger
> > , (select gevent.gevent
> > from gevent
> > where gevent.idx_gevt = glucose.gevent) as luEvent
> > FROM GLUCOSE
> > for update
> >
> > to that I have a DataSource component connected and to the DS I

have

> > an TIB_Update bar. The bar only has the "Edit, Delete, Post &

Cancel"

> > buttons visible. When I compile and run my app the Update bar is
> > greyed out and I cannot edit the data.
> >
> > The embeded select statements are linked to 2 lookup tables. I

tried

> > to follow the examples in the GSG but it looks like I am doing
> > something wrong.
> >
> > Any ideas what it might be that I am missing????
> >
>
> By default queries are only updatable when selecting from a single
> table.
>
> Thanks to Jason this is not necessarily true in IBO.
>
> You need to supply an EditSQL-statement.
> If you enter:
>
> UPDATE GLUCOSE SET
> GDATE=:GDATE,
> GTIME=:GTIME,
> GLEVEL=:GLEVEL,
> Finger=:FINGER,
> GEvent=:Gevent
> WHERE
> YOU_PK_FIELD_OR_STH_ELSE_THAT_UNIQUELY_IDENTIFIES_YOUR_RECORD =
> :VALUE_OF_IT_THIS
>
> in the EDITSQL property you should be able to edit the data.
>
> By the way:
> - i don't see any primary key field for GLUCOSE
> (shouldn't there be sth. like IDX_C6-H12-O6 ??? <g>)

I have a PK field, I just didn't select it...

>
> - wouldn't
> SELECT G.GDATE, G.GTIME, G.GLEVEL,
> F.Finger AS luFINGER,
> V.GEVENT AS luEVENT
> FROM GLUCOSE G
> LEFT JOIN FINGER F ON G.FINGER=F.IDX_FINGER
> LEFT JOIN EVENT V ON G.GEVENT=V.IDX_GEVT
>
> be a better sql syntax ???

I was just following the example in the Getting Started Guide so you
need to pose that question to Jason.

>
> Regards
> Luc.