Many Thanks Lucas(Leigh),

I been waiting a while for someone to answer. I have followed your advice,
and have made good progress(and learnt much), but I need to take the problem
one step further. I hope that what I still need to do is possible. I need to
use a TIB_LookupCombo(embedded in a grid) on one of those fields which are
updated via an sp in another (joined ) table. May I email you a small demo(a
picture is wor... etc) to have a look at?

Once again, thanks
Dion.

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 15, 2001 8:33 PM
Subject: Re: [IBO] ADVICE PLEEASE!!!


>
> Dion,
>
> As Leigh wrote, use a stored procedure.
>
> create procedure SP_TWO_TABLES

> T1_ID INTEGER,
> T2_ID INTEGER,
> T1_NAME VARCHAR(30), /* or whatever */
> T2_NAME VARCHAR(30),
> MYACTION CHAR(1)
> )
> as
> begin
> IF ( MYACTON = 'I' ) THEN
> BEGIN
> INSERT INTO Table_1 ( T1_ID, NAME ) VALUES ( :T1_ID, :T1_NAME );
> INSERT INTO Table_2 ( T2_ID, NAME ) VALUES ( :T2_ID, :T2_NAME );
> END
> ELSE IF ( MYACTION = 'U' ) THEN
> BEGIN
> UPDATE TABLE_1 SET T1_NAME = :T1_NAME WHERE T1_ID = :T1_ID;
> UPDATE TABLE_2 SET T2_NAME = :T2_NAME WHERE T2_ID = :T2_ID;
> END
> end;
>
> Now you can execute this procedure by using the UpdateSQL property of th
> TIB_Query.
>
> In the EditSQL you can enter:
> EXECUTE PROCEDURE SP_TWO_TABLE S( :T1_ID, :T2_ID, :T1_NAME, :T2_NAME,
> 'U' );
> and in the Insert SQL you can enter:
> EXECUTE PROCEDURE SP_TWO_TABLE S( :T1_ID, :T2_ID, :T1_NAME, :T2_NAME,
> 'I' );
>
> Note:
> - I added the MYACTION-param so tht you can use one proceudres for both
> actions: as well inserting as updating. If you don't need it, omit it.
> - The param-names of the procedure (in the edit-/insert-SQL) should
> reflect the fieldnames of your join.
> - set the RequestLive-property of your query to true
>
> HTH
> Luc.
>
>
>
> Dion schrieb:
> >
> > Hi all,
> >
> > I have spent a lot of time investigating the following problem and have
come to the conclusion that the problem can be only be solved by changing
the GUI and data input strategy, unless I am missing an important IBO
feature. I need to do the following:-
> >
> > Table_1
> > T1_ID
> > NAME
> >
> > Table_2
> > T2_ID
> > NAME
> >
> > Table_1_Table_2
> > T1_ID
> > T2_ID
> > T1_NAME
> > T2_NAME
> >
> > Grid
> > ------------------------------------------------------
> > T1_ID : T2_ID : T2_NAME :
> > ------------------------------------------------------
> > : : : :
> >
> > Is it possible to 'somehow' insert a record into Table_2 when I insert
into Table_1_Table_2 and edit the fields of Table_2(T2_NAME) from within the
context of the Table_1_Table_2 join. ie directly add the name from within
the Grid in this case?
> >
> > Many Thanks,
> > Dion.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > 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/
>
>