Call mySQL function from iReport Designer's "Report Query window.....

[robidomadenik]

Hello.

 

I'm using JasperSoft iReport  Designer 4.0.1  and I'm having trouble calling mySQL function from Report Query window.

I made this function in mySQL (SQL Manager 2005 for mySQL) and function works fine.

 

But when I want to use it like this from Report Query window in iReport Designer:

 

SELECT datum,  SPLIT_CONCAT('test','.')

FROM sk_2007_sak_programi

WHERE konto like '120%

 

....it doesn' work at all.'  It says: "SQL problems: FUNCTION razvoj_programi.SPLIT_CONCAT does not exist"

I used query language SQL or PLSQL, tried both and the same error.

 

Please...anybody??

 

Thanks, Robi

Code:

SELECT datum,  SPLIT_CONCAT('test','.')FROM sk_2007_sak_programiWHERE konto like '120%

[despec]

I can't be 100% certain, but I don't believe MySQL has such a function called "SPLIT_CONCAT"...I believe that's why you're getting the error.

 

David

[robidomadenik]

Hello.

 

As I said...this is MY custom made function :-)

Anyway doesn't matter anymore....I found another way solving my problem.

Thanks,

Robi

[ruudheemskerk]

Robi,

 

How did you solve this?

Regards Ruud

[vinayt]

Hi Robi,

 

How did you solve this problem. Am in the similar situation.

 

Thanks,

Vinay