Bug Tracker Incident #11963

 


Summary
Project
INCDT - OpenRPT
Incident Category
Bugs
Incident Number
11963
Visibility
public


Product Version
None
Fixed In Version
3.2.0-openrpt


Summary
Parameter Query does not work correctly on MySQL database


Description

When connected to MySQL database, and possible other non PostgreSQL databases, the Parameter Query fails and returns no results to the users.


Details
Reporter
cryan
CRM Account
xTuple
Status
Closed
Assigned
cryan


Priority
Normal
Severity
Minor
Updated
09-03-14 08:04
Resolution
Fixed - Unable to Verify



Comments

DateUsernameComment
09/03/14 08:04harika

Assuming that the issue is fixed. Closing the issue as 'Fixed - Unable to Verify.

08/25/14 08:07harika

Unable to verify the fix. Please suggest whether we can close this issue or not.

Regards,
Harika

03/04/11 08:25mfgadmin

Additional Info:

Sourceforge user gizmo1980 suggested following change to fix the problem:

In ORPreRenderPrivate::renderSection at line 781:

else if(f->data.query == "Parameter Query") {
str = _lstParameters.value(f->data.column).toString();
d_val = _lstParameters.value(f->data.column).toDouble(&isFloat);
}

That does the trick. And i did the same for the text fields...

This change does not take into consideration ordered parameter references. We could either drop that functionality or just modify the above to also support ordered parameter entrires.

03/04/11 08:25mfgadmin

When connected to MySQL database, and possible other non PostgreSQL databases, the Parameter Query fails and returns no results to the users.

09/09/10 09:51svn

Revision: 461
http://openrpt.svn.sourceforge.net/openrpt/?rev=461&view=rev
Author: cryan
Date: 2010-09-09 13:51:45 +0000 (Thu, 09 Sep 2010)

Log Message:
-----------
Incorporated suggested changes from user gizzmo1980. Issue #11963.

Modified Paths:
--------------
openrpt/trunk/OpenRPT/renderer/orprerender.cpp



Characteristics

Kickstart
None
KH-punchlist
No
Time Estimate
None
DatabaseURL
None
Points
None
BugHunt2012
None
Regression
No
CodeReview
None
Backport
No
Operating System
 
Doc Flag
False
Copyright Assigned
Yes
HaxTuple
No

Files

No Files

Related Documents

TypeNumberDescriptionRelationshipRemove
Incident355Customer w/ multiple invoice addressesParentx
ProjectOPENRPTPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
12/16/10 09:17acdrupalNewIncident Added
08/25/14 08:07harikaCharacteristic Backport Added: "No"
08/25/14 08:07harikaCharacteristic CodeReview Added: ""
08/25/14 08:07harikaCharacteristic Regression Added: "No"
08/25/14 08:07harikaCharacteristic BugHunt2012 Added: ""
08/25/14 08:07harikaCharacteristic Points Added: ""
08/25/14 08:07harikaCharacteristic databaseURL Added: ""
08/25/14 08:07harikaCharacteristic Time Estimate Added: ""
08/25/14 08:07harikaCharacteristic KH-punchlist Added: "No"
08/25/14 08:07harikaCharacteristic Kickstart Added: ""
09/03/14 08:04harikaStatusStatus Changed: Resolved -> Closed
09/03/14 08:04harikaResolutionResolution Changed: Fixed -> Fixed - Unable to Verify