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