iBase.ru Forum

>>kdv
>>hvlad

Спасибо! теперь все ясно.

CREATE PROCEDURE LOGIN ( I_LOGIN VARCHAR(25), I_PASSWORD VARCHAR(255)) RETURNS ( RESULT INTEGER, O_ERR VARCHAR(255)) AS DECLARE VARIABLE V_PSWD VARCHAR(255); BEGIN result = 0; SELECT password FROM users WHERE login = :i_login INTO v_pswd; IF (v_pswd IS NULL) THEN o_err = 'Invalid user name'; ELSE I...

например CREATE PROCEDURE LOGIN ( I_LOGIN VARCHAR(25), I_PASSWORD VARCHAR(255)) RETURNS ( RESULT INTEGER, O_ERR VARCHAR(255)) AS DECLARE VARIABLE V_PSWD VARCHAR(255); BEGIN result = 0; SELECT password FROM users WHERE login = :i_login INTO v_pswd; IF (i_password = v_pswd) THEN result = 1; ELSE BEGIN...