View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0014437||Lazarus||Database||public||2009-08-25 18:08||2009-09-10 22:41|
|Reporter||José Mejuto||Assigned To||Jesus Reyes|
|Product Version||0.9.27 (SVN)|
|Summary||0014437: SQLdb params bring down the IDE|
|Description||Trying to modify the "Params" of any SQL connection (Firebird, MySQL, Postgres,..) brings down the IDE in different ways.|
|Steps To Reproduce||Drop a SQL connection control in a form, edit the "params" field and add any text, press "OK". If you do not get an Access Violation, you can try to "edit" the params again and the text list is empty.|
Now try to exit the IDE, if you save you will get different streaming errors when trying to save with a final complete hangup which require a terminate process.
|Additional Information||I was trying to trackdown the problem without success as my knows about the Object Inspector are limited.|
Tested with 0.9.27 and 0.9.29 (today) and fcp 2.2.2, 2.4.0, 2.3.1 (about 2 weeks ago).
Setting params via code in the "BeforeConnection" event seems to work, so it looks more like a problem with the OI modifiying that particular TStrings.
Also "Params" in TSQLTransaction fails in the same way.
|Tags||No tags attached.|
|Fixed in Revision|
|Widgetset||GTK 2, Win32/Win64|
||I didn't get Access Violation, but I can confirm params was empty after second edit.|
This is a fpc problem, already reported and a patch was proposed. I couldn't reproduce the problem in TSQLTransaction on fpc 2.5.1
I can confirm that your patch solves the problem for all SQLConnections and Transaction. I had also tested almost the same patch but it had a "beginner" error assigning directly instead intead using Assign and replacing the FParams TStrings instead changing its content :(
||Can this issue be closed?|
||No sorry, the patch has not been applied, so the current code state is the same as before the bug report.|
||José, I may consider this issue as not-fixable in Lazarus, so this issue might as well be closed, nothing we can do about it. You can monitor the related fpc issue.|
OOops, you are right. I had posted it in Lazarus as at my first look I think it was an Object Inspector problem, which finally it is fpc's db.pas problem.
Fron Lazarus point of view it can be considered to not-fixable unless something can be added to the OI to detect that kind of problems, I think there are a bunch of similar properties published without getter/setter which can not be modified in OI without corrupting memory (most times not error or crash displayed).
If you think that something can be added to the OI let me know in the mailing list (or private mail) and I'll put a new bug report about that "problem".
Please resolve to not-fixable and directly close it. Thank you.
|2009-08-25 18:08||José Mejuto||New Issue|
|2009-08-25 18:08||José Mejuto||Widgetset||=> GTK 2, Win32/Win64|
|2009-08-25 18:32||Jesus Reyes||LazTarget||=> -|
|2009-08-25 18:32||Jesus Reyes||Note Added: 0030146|
|2009-08-25 18:32||Jesus Reyes||Status||new => confirmed|
|2009-08-25 20:23||Jesus Reyes||Status||confirmed => assigned|
|2009-08-25 20:23||Jesus Reyes||Assigned To||=> Jesus Reyes|
|2009-08-25 20:25||Jesus Reyes||Relationship added||related to 0014438|
|2009-08-25 20:26||Jesus Reyes||Note Added: 0030149|
|2009-08-25 20:34||Jesus Reyes||Note Edited: 0030149|
|2009-08-25 23:06||José Mejuto||Note Added: 0030152|
|2009-09-09 10:09||Vincent Snijders||Note Added: 0030561|
|2009-09-09 20:32||Jesus Reyes||Status||assigned => resolved|
|2009-09-09 20:32||Jesus Reyes||Resolution||open => no change required|
|2009-09-09 22:14||José Mejuto||Status||resolved => assigned|
|2009-09-09 22:14||José Mejuto||Resolution||no change required => reopened|
|2009-09-09 22:14||José Mejuto||Note Added: 0030575|
|2009-09-10 06:33||Vincent Snijders||Note Added: 0030583|
|2009-09-10 12:11||José Mejuto||Note Added: 0030593|
|2009-09-10 17:53||Jesus Reyes||Status||assigned => resolved|
|2009-09-10 17:53||Jesus Reyes||Resolution||reopened => not fixable|
|2009-09-10 22:41||José Mejuto||Status||resolved => closed|