Is my example clear for you Jason?

Thank you

--- In IBObjects@yahoogroups.com, "Cipto KH" <cipto.milis@...> wrote:
>
> Hi,
>
> I already uploaded file Cipto-IBO Bug 06Des12.rar in yahoogroups Files > Bug Testing Applications.
> I use Delphi 7, Firebird 2.1.5, IBO 4.9.14 52
>
> Bug is happen in design time when I want to Generate Edit SQL and Generate Insert SQL in IBOQuery component.
> The script to create the tables is already in the uploaded file.
>
> The query is like this:
>
> select d.id, d.idTbPOM, d.idTbPRD
> , rd.idTbBarang, rd.qty, rd.satuan, rd.qtyKecil, rd.keterangan
> FROM tbPOD d
> join tbPRD rd on rd.id=d.idTbPRD
>
>
> I think IBO is failed to translate the "d" table alias for tbPOD because the field from tbPRD are also included in the Edit SQL & Insert SQL of tbPOD table.
> The comment to reproduce this bug also included in the Delphi source.
>
> TIA
>
>
> [Non-text portions of this message have been removed]
>