New to writing procedures.

This is what I want to do.

MEM_ID INTEGER

IF (:MEM_ID > 0) THEN
<code>
ELSE
<code>
;
=====================

I get an error on ": MEM_ID" What am I doing wrong?

2nd question?

Can I use COMMIT in a stored procedure? I want to do several
things in the stored procedure

a) update a column
commit;
b) process a select statement
Set return values if found
c) Update a column
commit;

This would be simple in ORACLE, but of course I know PS/SQL.
I get an error when trying to use commit in the procedure.

TIA.



--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus