Hi,

At August 12, 2003, 19:04, Thomas Miller wrote:

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

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

It should be:
IF (MEM_ID > 0) THEN

> 2nd question?

> Can I use COMMIT in a stored procedure?

Unfortunately, No.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)