ADO and Store Procedure

[gbreed at cix.compulink.co.uk]

Joel Quinet wrote:

> There is a Unique Contsraint on that table.  If I try to insert an 
> existing
> value in that table with the following script,
> I receive no error ....
> I would like to receive an error and be able to deale with it.
> Moreover, My store procedure return 1 in case of problem.  How can I 
> rescue
> that ?
> How can I do that ?

Try returning a negative number, and you should get an exception 
triggered.  Otherwise, it's an ADO problem, and nothing in particular to 
do with Python.  Try microsoft.public.inetserver.asp.db

> rs, res = cmd.Execute()

You might find res has the right value, or you might have to initialize 
the recordset first.  cmd.Paramters.Refresh()?  I forget.  If you do 
something like cmd.Parameters("continent").Value = "Europe" that might do 
the trick as well, depending on what the parameter is called.  The return 
value might then be one of the parameters after you run the procedure.


                        Graham

           <http://www.microtonal.co.uk/>