Re: Store Procedure Variables

Hi Jerame, Have you tried putting a semi colon at the end of the create procedure line (i.e. ... contract_num INTEGER); ) Later Mark At 04:30 PM 11/20/00 -0700, Jerame Larsen wrote: I'm having extreme difficulty trying to figure out why this stored procedure is complaining when I try to create it. I am getting a syntax error on the DEFINE lines. I have tried moving BEGIN before and after it and I have tried other data types as well as different renditions of DECIMAL. Any suggestions? Jerame Larsen CREATE PROCEDURE "root".riviera(cardNum CHAR(25), amt DECIMAL(9,2), id CHAR(4), when DATETIME YEAR TO MINUTE, transId INTEGER, refNum CHAR(30), contract_num INTEGER) DEFINE prev_bal DECIMAL(9,2); DEFINE cbal DECIMAL(9,2); BEGIN SELECT credit_limit INTO prev_bal WHERE contract_id = contract_num; -- increase for a load IF id == 'LOAD' THEN LET cbal = prev_bal + amt; -- decrease for a remove ELIF id == 'RMVE' THEN LET cbal = prev_bal = amt; -- don't modify the balance if we don't know what it is that's coming through... -- ie BBAL records, or if we ever get a CRED or WDRW...these should never happen -- with Riviera because their cards are not transactable, but if it does. ELSE LET cbal = prev_bal; -- R_Memos Table Update INSERT (contract_id, type, cbal, extend(date, YEAR TO SECOND), ref_id) INTO r_memos VALUES (contract_num, id, cbal, when, refNum); -- Contract Table Update UPDATE contract SET credit_limit = cbal WHERE contract_id = contact_num; END PROCEDURE;