Error checking in Stored Proc => Vstudio console

[Ruslan Zasukhin]

On 21/9/07 12:11 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>>> Now the tbl_typelists has as you can see a field typelistname. This
>>> is defined to be unique
>>> 
>>> So when I call spBuildUserTypes again I expect to see 'something went
>>> wrong' in the console .Unique_key_violation should trigger the
>>> exception I believe.
>>> But the console prints "call spBuildUserTypes()" has been executed"
>>> When verifying the data nothing has changed (I still have 1 list with
>>> 3 items in it). So that is correct.
>>> So I guess the questions is why was the exception part of the
>>> procedure not executed ?
>> 
>> As I remember -- PRINT now prints into Warning log file.
>> 
>> To make it print into console of Vstudio -- we need build some bridge
>> between KERNEL and Vstudio. Right now it is absent...
>> 
>> Ivan, I have told people will not be happy just with log file ...
> 
> Peace, Love :-)
> 
> I think a nice solution would be that VStudio would have a switch
> were it can use the log file as console AND options to set the loglevel.

Not sure this is simple - to use disk file to load it each time .. File grow
in size.

We need that PRINT itself did have may be some kind of callback
    or return RAM string and VS catch it ...

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]