IS or =

[Ruslan Zasukhin]

On 20/9/07 3:23 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi list,
> 
> In this sp:
> 
> create or replace procedure spLogin(in vc_logon varchar,IN
> vc_password varchar)
> begin
> set @user_id = select recid from tbl_users where user_logonname =
> vc_logon AND user_password = vc_password;
> 
> IF @user_id IS NOT null
> or
> IF @user_id = NOT null
> end
> 
> I am a bit confused because when I read the WIKI grammar rules I see
> 
> boolean_test
>      : boolean_primary [ IS [ NOT ] truth_value ]
> 
> which indicates that the first statement is correct but VStudio does
> not seem to recognise IS (in the autocomplete within SQLEditor)

We need check this in Vstudio.


> TIA
> 
> Bart Pietercil
> 
> PS: sorry to come up with all those question but I need to get up to
> speed with stored procedures

We want MORE !!! :-)

-- 
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]