Hi

dimasalt wrote:

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

Can you describe or give more details what do you want the procedure to
perform?

James