2. ASPRunnerPro General questions
  3. Error
This topic is locked

Error

 		1/4/2005 3:12:58 PM
ASPRunnerPro General questions
K
 kevinl author

Hi Everyone,
Need a little help with this, everytime i edit, add or delete. It give off this error but still update the change, add new but wont delete the record.
Here the code
[CODE]ASP error happened

Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server][Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'AML_SVCDB_TEST Web Page'.

SQL query insert into [dbo].[SVCServiceAgreements] (SVCItemNumber, LotSerialNumber, StartDate, ItemNumber, CustomerNumber, OrderNumber, OrderSequenceNumber, RecordCreationDateTime) values ('903', '903', '12/12/04', '903', '903', '903', '903', '12/12/04')
Please help.
Sergey Kornilov admin 1/8/2005

Hi,
check if you have any triggers for DELETE, ADD or UPDATE.
It sounds like you have a trigger that refers to missing 'AML_SVCDB_TEST Web Page' stored procedure.