Re: Syntax for Stored Procedure Pervasive 8x

Well it is now working, not sure what the problem was.
Here is the working code for the Update Stored procedure:

-- ajb 11/19/2006
-- Update TheDescription
CREATE PROCEDURE spUpdateTest();
BEGIN
update "Part Master" set "Part Master".PMDES1_01 = '1'
where "Part Master"."UDFKEY_01" ='R' OR "Part Master"."UDFKEY_01" ='RS'

AND POSITION('~', "Part Master".PMDES1_01) = 0;

END;



-andy

.