View Issue Details

IDProjectCategoryView StatusLast Update
0034686LazarusDatabasepublic2019-09-12 04:30
ReporterValdir MarcosAssigned ToMattias Gaertner 
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
Platform32bitOSWindowsOS Version7 and 10
Product Version2.0RC2Product Build59712M 
Target VersionFixed in Version 
Summary0034686: Database Settings -> confunsing information and possibility of setting wrong values
Description1. Attached image shows that I can see and select wrong SQLTransaction components that are neither on form itself nor in its Uses list. Same behavior for properties such as Database, Transaction, DataSource, etc.

Coming from Delphi, I think that the possibility of setting wrong information is a problem, but I was told this is by Lazarus design:
"Error - Transaction of connection not set"
http://forum.lazarus.freepascal.org/index.php/topic,42410.msg296241.html#msg296241

2. Pollution caused by wrong information and its consequences.

Thinking about a project with hundreds of forms and data modules, showing wrong information that is not related to that SQLQuery component turns out to be a type of pollution that lowers productivity and assertiveness and increases the chance of errors. As it's happening now, some of those errors are very difficult to solve because one does not know their origin or how to build a sample project to reproduce the problem.
Steps To ReproduceCreate a project with many datamodules and forms with many TIBConnection, TSQLTransaction, TSQLQuery and TDatasource.
Having many data modules and forms opened simultaneously shows the problem.

I have attached a small project that shows the problem. As the project grows to hundreds of data modules and forms, the problem becomes a real nightmare.
TagsNo tags attached.
Fixed in Revision
LazTarget-
WidgetsetWin32/Win64
Attached Files

Activities

Valdir Marcos

2018-12-12 05:11

reporter  

IBConnection multi transaction error.zip (186,295 bytes)

Valdir Marcos

2018-12-12 05:11

reporter  

lazarus 06.jpg (42,707 bytes)
lazarus 06.jpg (42,707 bytes)

Michael Van Canneyt

2018-12-12 10:11

administrator   ~0112504

I know this problem very well, and I agree it should be fixed.

Valdir Marcos

2018-12-13 20:25

reporter   ~0112547

Last edited: 2019-09-12 04:30

View 2 revisions

Please, fix "confunsing" on Summary of this ticket.
The correct word would be "confusing".
Thanks.

Issue History

Date Modified Username Field Change
2018-12-12 05:11 Valdir Marcos New Issue
2018-12-12 05:11 Valdir Marcos File Added: IBConnection multi transaction error.zip
2018-12-12 05:11 Valdir Marcos File Added: lazarus 06.jpg
2018-12-12 10:11 Michael Van Canneyt LazTarget => -
2018-12-12 10:11 Michael Van Canneyt Note Added: 0112504
2018-12-12 10:11 Michael Van Canneyt Assigned To => Michael Van Canneyt
2018-12-12 10:11 Michael Van Canneyt Status new => acknowledged
2018-12-12 10:11 Michael Van Canneyt Assigned To Michael Van Canneyt => Mattias Gaertner
2018-12-12 10:11 Michael Van Canneyt Status acknowledged => assigned
2018-12-13 20:25 Valdir Marcos Note Added: 0112547
2019-09-12 04:30 Valdir Marcos Note Edited: 0112547 View Revisions