abungas Posted June 18, 2009 Share Posted June 18, 2009 Good Day,, Any body can help me about OpenbravoERP reports on How to Edit?I use OpenbravoERP 2.40 and i.report 2.02I already know where and what to edit the problems is when i try to Ad the Query their is Always and Error....(Error:SQL Problems:ERROR: Syntax error at near ",")This Are the Query statementSELECT C_ORDER."C_ORDER_ID", C_ORDER."DATEORDERED", C_ORDER."DOCUMENTNO", C_ORDER."DATEPROMISED",<----------------------------------this is i add the other are the original Query statement C_BPARTNER."NAME", C_BPARTNER_LOCATION."FAX", C_BPARTNER_LOCATION."PHONE", REPLACE(C_ORDER.DESCRIPTION,CHR(10),'')AS DESCRIPTION, REPLACE(C_ORDER.DELIVERYNOTES,CHR(10),'')AS DELIVERYNOTES, AD_CLIENT."DESCRIPTION" AS ENTITY, C_LOCATION_DESCRIPTION(AD_ORGINFO.C_LOCATION_ID)AS LOCATION, FREIGHTCOSTRULE.NAME AS DELIVERYEXPENSE, DELIVERYRULE.NAME AS DELIVERYTERM, C_CURRENCY."ISO_CODE", PAYMENTTERM.TERM AS PAYMENTTERM, VALUE, NAMEFROM "C_ORDER" C_ORDER INNER JOIN "C_ORDER" C_BPARTNER_LOCATION ON C_ORDER."BILLTO_ID" = C_BPARTNER_LOCATION."C_BPARTNER_ID", "C_BPARTNER" C_BPARTNER, "AD_ORGINFO" AD_ORGINFO, "AD_CLIENT" AD_CLIENT, "C_CURRENCY" C_CURRENCY, "(" (, "AD_REF_LIST_V" AD_REF_LIST_VWHERE AD_REFERENCE_ID = 153 AND AD_LANGUAGE = $P{LANGUAGE} Pls Any one can help me on how to do it Correctly PLS HELPYour Responds highly appreciated Link to comment Share on other sites More sharing options...
mdahlman Posted June 18, 2009 Share Posted June 18, 2009 abungas, Your FROM clause doesn't look so good. Mixing one INNER JOIN clause with a bunch of unjoined tables will be hard to use even if you get it to work. Try converting the whole thing to use JOIN clauses linking the tables. Start by testing it outside of iReport. Use a tool like SQuirreL. (Any SQL tool is fine, but SQuirreL is a great free tool for testing JDBC connections.) After you confirm that the SQL is OK there, then put it back into the report and test in iReport. Regards,Matt Link to comment Share on other sites More sharing options...
abungas Posted June 19, 2009 Author Share Posted June 19, 2009 Good Day thank You very much for the info. but i hope you could guid me in this... 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