Parse Statement causes a "hang" in crystal reports - Mailing list pgsql-odbc

From Wayne Armstrong
Subject Parse Statement causes a "hang" in crystal reports
Date
Msg-id 200304110317.h3B3Hgdv029827@mail.bacchus.com.au
Whole thread Raw
List pgsql-odbc
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"


Regards,
Wayne


pgsql-odbc by date:

Previous
From: "Hollysugar Webmaster"
Date:
Subject: New problem with sqlsetpos -->support for adding rows?
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database