LastErrorNumber & LastErrorMessage

[Ivan Smahin]

Hello Bart,

Wednesday, October 10, 2007, 11:39:08 PM, you wrote:

> Now to the point

> 1) (minor point) Why in the print line it says id 327681 when I raise
50001---->> Hex ?
Yes it is decimal representaion of 0x50001

> 2 when I call the cm_spLogin like this:

> call cm_spLogin('test','b210364');
> select @@LastErrorNumber AS 'ErrorID', @@LastErrorMessage as  
> 'ErrorMessage';age;


> it get the correct print line in warning_log but the cursor looks like:
> ErrorID = 0 and ErrorMessage = <Null>

> Are the @@Variables immediately reset when being read(printed) once ?

Exactly. You can read it only once.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com