By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,423 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,423 IT Pros & Developers. It's quick & easy.

How to trace the Insert Query of Sql Data Source ?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.