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

From Hiroshi Inoue
Subject Re: Parse Statement causes a "hang" in crystal reports
Date
Msg-id 3E9A26C9.E4CE8D52@tpf.co.jp
Whole thread Raw
In response to Parse Statement causes a "hang" in crystal reports  ("Wayne Armstrong" <wdarmst@bacchus.com.au>)
Responses An extra null row is returned if rowset size is a multiple of row cache size
List 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/


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: lo_import doesn't works through ODBC !
Next
From: "Hollysugar Webmaster"
Date:
Subject: Re: doubt