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
Resolved
Assigned
cryan


Priority
Normal
Severity
Minor
Updated
09-21-11 14:29
Resolution
Fixed



Comments

DateUsernameComment
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

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

 

mead