L
Luqman
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
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