Hello!
I did not use procedure.
i have person_info on one table, and in the second i have events number.
event relation to person_info is many to one.
I remove all my work. This was something like this:

SELECT events.* , first_name, last_name FROM events join person_info on
events.person_id = person_info.person_info_id.
I set RequestLive to true, and KeyRelation to
person_info.person_info_id (or events.person_id).
And put some SQL for the update and insert SQL.
could i put in this table other join to the names of the events from other
table, and select the type of the event with lookup?
I Would want edit data from the query inside the grid itself.
Coulf it be done?
I am sorry about my english.


-----Original Message-----
From: Claudio Valderrama C. [mailto:cvalde@...]
Sent: Sunday, January 21, 2001 11:35 PM
To: IBObjects@egroups.com
Subject: RE: [IBO] continue of my problem AND edit_mode of the grid is false


Since it's hard to guess your settings, can you post your main SQL statement
and your *SQL properties? Are you calling a procedure or not? If not, did
you set KeyRelation and RequestLive?

C.

> -----Original Message-----
> From: Meir Kalter [mailto:meir_klt@...]
> Sent: Domingo 21 de Enero de 2001 4:39
>
> I solved my first problem after i give a special SQL for the update and
> insert.
> Now all i have is problem how to enable the editing inside the grid.
> I can not edit nothing inside the grid ,
> when i add JOIN to the query.
> Please , help me!!!!!!!!
>
>
>
>