SIGSEV error due to circular reference between SQLQuery and DataSource
Original Reporter info from Mantis: kStarbe
-
Reporter name: xGo
Original Reporter info from Mantis: kStarbe
- Reporter name: xGo
Description:
I wanted to display a MySQL query result in a grid. So I added the following components:
MySQL56Connection
SQLTransaction
SQLQuery
DataSource
DBGRid.
Then linking the objects together I select
SQLTransaction.database to MySQL56Connection
SQLQuery.Database to MySQL56Connection
SQLQuery.Transaction to SQLTransaction
SQLQuery.Datasource to Datasource (!)
Datasource.Dataset to SQLQuery
Datagrid.Datasource to Datasource.
Run the app, saw the data but as soon as I try to move the record, I got the above message.
[Window Title]
Error
[Content]
Project MySQL raised exception class 'External: SIGSEGV'.
At address 585882
[OK]
After lots of searches, I did look at the whole chain and noticed there was a circular reference between the Datasource and the SQLquery. the line above with the ! at the end is not correct. But the interface marks the datasource in red tempting user to fill it in.
Fun is that if you first set the link between SQL and Source from the Source fisrt, then you cannot set it on top from the SQL side. This warns you that a circular reference is there.
In the ohter direction, first set the datasource in the SQL and then the SQL in the datasource then no error but the SIGSEGV.
So there should be a similar check in both components.
Steps to reproduce:
Described above.
Additional information:
Using XAMPP version 5.6.23. And connector for MySQL/C version 5.6.6 (libmysql.dll)
Mantis conversion info:
- Mantis ID: 30379
- OS: Vista
- OS Build: Home Edition FR
- Platform: Windows
- Fixed in version: 3.3.1
- Fixed in revision: 43143 (#7e9e0e19)
- Target version: 3.2.0