Click here to Skip to main content
15,611,801 members

Comments by Dougie the P (Top 4 by date)

Dougie the P 3-Aug-12 1:04am View    
Please repost your current code reflecting the changes you have made and what your contiuing problems are.
Dougie the P 2-Aug-12 20:28pm View    
You need to use an UPDATE statment not a INSERT statment in your trigger to update the QID,QNo,QID_No columns in the inserted record rather then insert a new row.
Dougie the P 2-Aug-12 20:00pm View    
if the data represented by DVGPO.Rows is the detail records of a PO and you want the PO header information saved with each detail row, then move the comd.ExecuteNonQuery() line inside the for next loop. If not then a rethinking of the database structure maybe required. there is not enough information supplied in the question to properly evaluate your intentions.

The important comments by Wes should also be taken in to consideration
Dougie the P 30-Jul-12 18:16pm View    
Thanks Sergey, I Have done so.