Hello!
This is a second message, because i have some mistakes.
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 need to join data from 3 tables!
I Would want edit data from the query inside the grid itself, as it can be
with query just from one table.
Could it be done?
When there is 'JOIN' in the query, i can not edit filelds on the grid.
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!!!!!!!!
>
>
>
>