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