fujidaa Posted September 19, 2011 Share Posted September 19, 2011 I try to run below code in oracle and everything's fine. But when i try to use it in iReport (parameter replace the date) I get ORA-00933: SQL Command not properly ended .what i need to do to make it function in iReport? Code:Oracle:SELECT Cdate, receiptFROM cashWHERE Cdate >'20110523' AND Cdate<'20110525'ORDER BY receiptReport query in iReport:SELECT Cdate, receiptFROM cashWHERE $P{pFrom}ORDER BY receipt$P{pFrom}:" and Cdate >="+$P{pFrom}$P{pFrom} :in date format, accept data from user Link to comment Share on other sites More sharing options...
despec Posted September 19, 2011 Share Posted September 19, 2011 The code should be; select Cdate, receipt from cash where Cdate >= $P{pFrom} David Link to comment Share on other sites More sharing options...
fujidaa Posted September 21, 2011 Author Share Posted September 21, 2011 yay! thank you very much despec. it solved my problem /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now