carartsuamor

Hi, I already solve last mistake, It was about a date but I see sqlite don't support the parameter between a date substract, I use (STRFTIME('%J','NOW','START OF MONTH') - STRFTIME('%J',EVC.FECHA)) AS ANTIG_SEGMENT now I got another problems with I-report : The query work but in the execute of the report appear an error was found about null key arguments, I think that's about the graphics I have in the report that's way I cut them and the report work, but I check the graphic data source and there is nothing wrong Second I have a big problem with the cast between long, like I explained previewsly I migrated from hsql to sqlite but I-report work good with the report that have shqldb, but it doesn't when I change the database source from sqlite. this is the error: The method longValue() is undefined for the type Object when I try to convert I field from the table to a longValue like this Code:($F{ANTIGUEDAD_CLIENTE}.longValue() <= 3 ? new String ("3"):($F{ANTIGUEDAD_CLIENTE}.longValue() > 3 && $F{ANTIGUEDAD_CLIENTE}.longValue() <= 6 ? new String ("6"):($F{ANTIGUEDAD_CLIENTE}.longValue() > 6 && $F{ANTIGUEDAD_CLIENTE}.longValue() <= 12 ? new String ("12"):($F{ANTIGUEDAD_CLIENTE}.longValue() > 12 && $F{ANTIGUEDAD_CLIENTE}.longValue() <= 24 ? new String ("24"):($F{ANTIGUEDAD_CLIENTE}.longValue() > 24 && $F{ANTIGUEDAD_CLIENTE}.longValue() <= 60 ?new String ("60"):($F{ANTIGUEDAD_CLIENTE}.longValue() > 60 && $F{ANTIGUEDAD_CLIENTE}.longValue() <= 120 ?new String ("120"):new String ("121")))))))

Hi, I found I big deal with the parameter while I was migrating from hsql db to sqlite, when I build a query I need to put some parameters into the from clause about the date i.e: birth_date<$P{mydateParam} This is suported by hsql but when I ran the query with sqlite it can't be recognized Thanks, Carlos Suarez

CaptnTony Wrote: That looks like it did the trick! Went to 1.2.5 of JR and iReports 1.2.5 as well. Thank you much. Could someone tell me where can I get a method for SQL documentation, I'm looking for a way to document every query I create in I-report with coments and descriptions about sentences, fields, alias, tables, subqueries and stuff aliked. Thanks, Carlos S.