Can somebody please help me with stored procedure, i try make
procedure that make select action, i get error from FirebirdSql on
procedure compilation, is there special way do procedures that make
select action ? If yes, how i do it ?
I actualy want return all data to DataSet (i make project on ASP.NET
C#, and then i check it there.

here is the procedure code i ty use:

CREATE PROCEDURE IF_USER_EXIST (
LOGINNAME VARCHAR(20))
AS
begin
SELECT * FROM fo_users WHERE us_name = :LOGINNAME ;
suspend;
end