I am using the ADO command object.
in the command text i am using an SQL
after i execute the command how do i get
the sql code returned by the database.
database in question -DB2 UDB
i am using ODBC connection to Access DB2
set cmd = new ADODB.command
cmd.commandtext="update employee set pay = 200 where emp_cd = 20"
What happens if the employee_cd = 20 does not exist ,how can i trap it in the next line after the execute.
Any help will be appreciated