From: | "Chris Hoover" <revoohc(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Any way to see parameters |
Date: | 2007-09-11 21:02:08 |
Message-ID: | 1d219a6f0709111402yc8329ffx71fa6eb8a6bb131@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2007-09-12 07:54:35 | Re: Any way to see parameters |
Previous Message | Abhishek Srivastava | 2007-09-11 11:47:01 | Re: IODBC 3.52 with psqlODBC-08.02.0400 |