Any way to see parameters - Mailing list pgsql-odbc

From Chris Hoover
Subject Any way to see parameters
Date
Msg-id 1d219a6f0709111402yc8329ffx71fa6eb8a6bb131@mail.gmail.com
Whole thread Raw
Responses Re: Any way to see parameters  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
We are having some issues in our development shop, and I wanted to know if there is any way to see the parameters passed in a query in the odbc log.  I have turned debug on, and I am getting a log of all of the queries.  I see the parameters after they are added into the query, but I would like a listing of each parameter value before the query substitution occurs.  Is there anyway to see this?

Example:
PGAPI_Execute: clear errors...
PGAPI_Execute: copying statement params: trans_status=2, len=75, stmt='UPDATE CLMCOM1 SET SUBMIT_L_NAME_ORG = ? WHERE INV_NBR = ? AND INV_QFR = ? '
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?
copy_statement_with_params: from(fcType)=4, to(fSqlType)=4  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?

Thanks,

Chris

pgsql-odbc by date:

Previous
From: "Abhishek Srivastava"
Date:
Subject: Re: IODBC 3.52 with psqlODBC-08.02.0400
Next
From: Ludek Finstrle
Date:
Subject: Re: Any way to see parameters