469,950 Members | 2,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

How to trace the Insert Query of Sql Data Source ?

I have created a Insert Query in Sql Data Source using Oracle Database, with
the parameters, and its connected with DetailView Control.

When I try to Insert through DetailView Control, Illegal Variable
Name/Number Error occurs.

Is there any way I can trace or display on screen, what exactly the query is
being passed to the Oracle with the Values.

For example: If my Sql datasource has following query.

Insert into mytable(invoice_no,inv_date,item_no,qty)
values(:invoice_no,:inv_date,:item_no,:qty)

I need the query with the parameter values as under:-

Insert into mytable(invoice_no,inv_date,item_no,qty)
values(1241,'23-jun-2006',12,1200)

How can I trace and display the above query with the parameter values ?

I am using VS 2005.

Best Regards,

Luqman


Jul 10 '07 #1
1 2552
Parameters are processed by the database driver. I don't think you can see
the actual sql at any point prior the driver gets the statement.

Don't know much about Oracle tracing tools but there should be some, use
them.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Luqman" <pe*******@cyber.net.pkwrote in message
news:Oq***************@TK2MSFTNGP03.phx.gbl...
>I have created a Insert Query in Sql Data Source using Oracle Database,
with
the parameters, and its connected with DetailView Control.

When I try to Insert through DetailView Control, Illegal Variable
Name/Number Error occurs.

Is there any way I can trace or display on screen, what exactly the query
is
being passed to the Oracle with the Values.

For example: If my Sql datasource has following query.

Insert into mytable(invoice_no,inv_date,item_no,qty)
values(:invoice_no,:inv_date,:item_no,:qty)

I need the query with the parameter values as under:-

Insert into mytable(invoice_no,inv_date,item_no,qty)
values(1241,'23-jun-2006',12,1200)

How can I trace and display the above query with the parameter values ?

I am using VS 2005.

Best Regards,

Luqman


Jul 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Philip Boonzaaier | last post: by
16 posts views Thread by robert | last post: by
2 posts views Thread by Jason L James | last post: by
2 posts views Thread by Geoffrey KRETZ | last post: by
7 posts views Thread by David Bear | last post: by
5 posts views Thread by Mr. SweatyFinger | last post: by
6 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.