Hi everyone!

I need help me store procedure. Anyone can help me ? On goto error x in store procedure like in vb.

Max

do you mean "on error goto x"????



if so try it like this



private sub test()



on error goto errortrap



some code....



exit sub



errortrap:



some code...



end sub

LAURENCE VALENTINE™

That works good in VB but SQL doesn't support On Error.