From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Wayne Armstrong <wdarmst(at)bacchus(dot)com(dot)au> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Parse Statement causes a "hang" in crystal reports |
Date: | 2003-04-14 03:11:05 |
Message-ID: | 3E9A26C9.E4CE8D52@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Wayne Armstrong wrote:
>
> Hi,
> If I have parse statements turned on and the following sql is issued from
> crystal reports, crystal will just hang.(ugly aint it :) This happens because
> the parser decides ( is the schema, and dies trying to get info on a table
> called (.bacchus. This is in the 7.02.00.05 drivers.
>
> SELECT "MGMT_SUMMARY2"."vehicle_code", "MGMT_SUMMARY2"."t_kms", "MGMT_SUMMAR
> Y2"."t_fuel_cost", "MGMT_SUMMARY2"."t_fuel_qty", "MGMT_SUMMARY2"."cost_per_klm",
> "MGMT_SUMMARY2"."fuel_ecomony", "MGMT_SUMMARY2"."t_job_cost", "MGMT_SUMMARY2"."
> t_part_cost", "MGMT_SUMMARY2"."t_labour_cost", "MGMT_SUMMARY2"."t_labour_hour",
> "PLANT"."year_made", "PLANT"."model_code", "PLANT"."active_flag", "PLANT"."print
> _flag", "TB_CONTROL"."report_start", "TB_CONTROL"."report_end", "MGMT_SUMMARY2".
> "t_oil_cost", "MGMT_SUMMARY2"."t_tyre_cost", "company"."company_name", "MGMT_SUM
> MARY2"."company_id" FROM (("bacchus"."mgmt_summary2" "MGMT_SUMMARY2" LEFT OUTE
> R JOIN "bacchus"."plant" "PLANT" ON ("MGMT_SUMMARY2"."company_id"="PLANT"."compa
> ny_id") AND ("MGMT_SUMMARY2"."vehicle_code"="PLANT"."plant_code")) LEFT OUTER JO
> IN "bacchus"."tb_control" "TB_CONTROL" ON "MGMT_SUMMARY2"."company_id"="TB_CONTR
> OL"."company_id") LEFT OUTER JOIN "bacchus"."company" "company" ON "MGMT_SUMMARY
> 2"."company_id"="company"."company_id" WHERE "PLANT"."active_flag"='Yes' AND "M
> GMT_SUMMARY2"."company_id"=0 AND "PLANT"."print_flag"='Yes' ORDER BY "PLANT"."mo
> del_code", "MGMT_SUMMARY2"."vehicle_code"
Please try the lastest snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/ .
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Juan | 2003-04-14 08:28:54 | Re: doubt |
Previous Message | Hiroshi Inoue | 2003-04-14 02:57:28 | Re: lo_import doesn't works through ODBC ! |