| Subject | Bugs in design time when Generate Edit SQL & Insert SQL |
|---|---|
| Author | Cipto KH |
| Post date | 2012-12-06T17:16Z |
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]
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]