Parse Statement causes a "hang" in crystal reports

From: "Wayne Armstrong" <wdarmst(at)bacchus(dot)com(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Parse Statement causes a "hang" in crystal reports
Date: 2003-04-11 03:15:53
Message-ID: 200304110317.h3B3Hgdv029827@mail.bacchus.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-04-11 09:27:34 Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Previous Message Hollysugar Webmaster 2003-04-10 20:28:24 New problem with sqlsetpos -->support for adding rows?