Error checking in Stored Proc => Vstudio console

[Bart Pietercil]

On 21-sep-07, at 11:06, Ruslan Zasukhin wrote:

> On 21/9/07 11:19 AM, "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.

Bart