kirkholt
Posts: 1
|
| Posted: 06/13/2006, 1:08 AM |
|
Hello
I'm using ASP and MS sql server 2000
I have and SP that are called from several record-forms.
The SP is call from the after insert / after update / after delete event like this:
Function Tilbud_Villa_AfterUpdate(Sender) 'Tilbud_Villa_AfterUpdate @135-06BEFB6D
'Custom Code @230-73254650
' -------------------------
' Write your own code here.
call MTberegnTilbud(Sender)
' -------------------------
'End Custom Code
End Function 'Close Tilbud_Villa_AfterUpdate @135-54C34B28
The function MTberegntilbud is placed in common.asp and looks like this:
sub MTberegnTilbud(sender)
Set sender.command.Connection = Sender.datasource.Connection
sender.command.CommandType = dsProcedure
sender.command.SP = "Beregntilbud;1"
sender.command.Parameters.ParameterSources("sestilbud_id") = Session("tilbud_id")
sender.command.CommandParameters = Array(Array("@tilbud_id", "sestilbud_id", adInteger, adParamInput, 0, 0, 10, Empty, Empty))
Set sender.command.Parameters.Connection = Sender.datasource.Connection
sender.command.Parameters.AddParameter "@tilbud_id" , "sestilbud_id", ccsInteger, Empty, Empty, Empty, False
sender.command.exec(sender.errors)
end Sub
The problems is that if an error ocurs in the SP, the error is not shown in the record form.
How do I show an error from the SP on the record form ?
Best regards
Ole Kirkholt
MicroTech Software
|
 |
 |
|
