Subject Create procedure -- newbie coming from ms sql server
Author martindevroom
Hi,

This is going to sound like a real dumb question to tou probabally.
Firstly, my background is in ms sql server, and I have been looking
at firebird for the first time today.
So I manged to create a table and populate it wil data.. hooray..

CREATE TABLE TBLMARTIN (
FIELD1 SMALLINT,
FIRSTNAME VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251);

insert into TBLMARTIN (FIELD1,Firstname) values
(1,'martin') /*several time*/

next I wrote a simple select statement and again it worked.

select FirstName from TBLMARTIN

then a decieded to encapsulate my select query into a stored
procedure. This is where I hit real problems.
I would have expected the following to work

CREATE PROCEDURE FirstProcedure
AS
BEGIN
select FirstName from TBLMARTIN;
END

but it doesn't.

I have a million more questions about firebird and finding
documentation is proving troublesome.

Can anybody please point me to some tutorials that will help me
accomplish tasks similar to above such as writing tiggers,udf's,
views ect..

any help i appreciated.

cheers

martin.