Subject Re: Editing a TIB_Query
Author gsbrown@GerBreOwn.com
--- In IBObjects@egroups.com, Helen Borrie <helebor@w...> wrote:
> Gerald,
>
> What KeyLinks do you have for this dataset?
GB IDX_GLUC=GEN_GLUCOSE. GEN_GLUCOSE is a generator that I created.
>
> Where/what is the primary key?
GB IDX_GLUC, which was not in my select statement. I have added it
and now the query is editable.

GB I still have a problem understanding how to use a TIB_LookupCombo
in a grid. I have been trying to follow the examples in the GSG but
it doesn't seem to work for me. I have 2 LUCombos that work fine if
on the form but when dropped on the grid they don't work/are not
visible. What I am trying to do is: In my glucose table a field
called "Finger" is an integer. In my "Finger" table the PK is an
integer and the glucose table matches to that. If the user changes
the finger in the LUCombo the number in glucose.finger should change.

Thanks,
Gerald S. Brown
>
> H.
>
> At 07:43 PM 20-12-00 +0000, you wrote:
> >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????
> >
> >Thanks,
> >
> >Gerald S. Brown
> >
> >
> >
>
> All for Open and Open for All
> InterBase Developer Initiative ยท http://www.interbase2000.org
> _______________________________________________________