Subject Re[2]: [IBO] IBO / Firebird 3 - problems with inserting rows
Author Marcin Bury
Jason

I have sent you the direct email with dtails. Did you get it?

Marcin

------ Wiadomość oryginalna ------
Od: "'IBO Support List' supportlist@... [IBObjects]"
<IBObjects@yahoogroups.com>
Do: IBObjects@yahoogroups.com
Wysłano: 16.06.2016 18:22:26
Temat: RE: [IBO] IBO / Firebird 3 - problems with inserting rows

>Would you open up the unit testing project RegTest_GUI in the
>ibo\build\RegressionTest sub folder and see if you can make a
>regression
>test that will isolate this problem? Then, send me the procedure you
>added
>along with the DDL file, etc. it may require.
>
>If you aren't familiar with unit testing I'll give a brief overview of
>it. I
>highly recommend everyone making use of this for their projects.
>
>Thanks,
>Jason Wharton
>www.ibobjects.com
>
>
>-----Original Message-----
>From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
>Sent: Thursday, June 16, 2016 1:31 AM
>To: IBObjects@yahoogroups.com
>Subject: [IBO] IBO / Firebird 3 - problems with inserting rows
>
>Hello All
>
>I'm facing a strange problem with IBO working with Firebird 3 database.
>When the query contains subselect and tables aliases are in use, IBO
>apparently has problem obtaing proper keyrelation that leads to false
>result of CanInsert function.
>Having query like this
>
>SELECT A.FIELD_1, A.FIELD_2, (SELECT B.FIELD_3 FROM TABLE_B B WHERE
>B.KEY_FIELD = A.FIELD_2) B_FIELD
>FROM TABLE_A A
>
>When executed on FB3 - IBO findes two aliases, then FRelAliasList
>contains two items and SysKeyRelations is always <empty_string>
>
>Funny thing is that same query executed on FB 2.5 works properly.
>
>Any ideas?
>
>Thanks,
>Marcin
>
>
>
>------------------------------------
>Posted by: "Marcin Bury" <marcin.bury@...>
>------------------------------------
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or
>InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info
>papers,
>keyword-searchable FAQ, community code contributions and more !
>http://tracker.ibobjects.com - your portal to submit and monitor bug
>reports
>http://community.ibobjects.com - your portal to purchase and upgrade
>------------------------------------
>
>Yahoo Groups Links
>
>
>
>
>
>------------------------------------
>Posted by: "IBO Support List" <supportlist@...>
>------------------------------------
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or
>InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info
>papers,
>keyword-searchable FAQ, community code contributions and more !
>http://tracker.ibobjects.com - your portal to submit and monitor bug
>reports
>http://community.ibobjects.com - your portal to purchase and upgrade
>------------------------------------
>
>Yahoo Groups Links
>
>
>