How do you reference a row in an SQL INSERT command?

[JeremyM]

I need to add (insert using SQL) a row from a listview report when the ADD button is selected. I can figure out the sql. But does anyone know a way to reference the highlighted field as being the one to INSERT?

ie: Part Desc
3213-151 Metal
3213-455 Wood

I want to add the patr and desc of the selected row to another table. How do you reference the row. The row comes from a list view report.

Thanks,
Jeremy

 

[culshaja]

You can get at the data that has been selected using the

SelectedItem

property of the ListView control.
Hope this provides a good starting point.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[JeremyM]

ok Thanks.

I got it working.