Subject | RE: [IBO] SQL-Problem II |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-01-04T04:12:22Z |
Use the events that TIB_Query has:
OnCustomDelete
OnCustomEdit
OnCustomInsert
You can take full control on those if the *SQL properties aren't enough for
your case.
C.
OnCustomDelete
OnCustomEdit
OnCustomInsert
You can take full control on those if the *SQL properties aren't enough for
your case.
C.
> -----Original Message-----
> From: guido.klapperich@... [mailto:guido.klapperich@...]
> Sent: Jueves 21 de Diciembre de 2000 11:39
> To: ibobjects@egroups.com
> Subject: [IBO] SQL-Problem II
>
>
> Some time ago I had the problem, that I have to display two or more rows
> of a table in just one row in a Query. Something like that:
>
> ID | VALUE
> 1 | 25.0
> 2 | 13.0
>
> And the result of the query looks:
>
> a.ID | a.VALUE | b.ID | b.VALUE
> 1 25.0 2 13.0
>
> I solved the problem, with the query Helen told me:
> select a.ID, a.VALUE, b.ID, b.VALUE from
> MYTABLE a, MYTABLE b where
> a.ID=1 and b.ID=2
>
> Now I have the problem, that this query should be editable. In the grid,
> that displays this query a.VALUE and b.VALUE should be editable. But
> when I try to post the query, it doesn't know, which VALUE belongs to
> which ID.
> Exists there a solution for my problem, for example a UpdateSQL, that I
> have to built dynamicly ?
>
>
> Guido.
>
>
>
>
>
>