Re: Syntax for Stored Procedure Pervasive 8x

Thanks Bill unfortunetly I'm not quite there

CREATE PROCEDURE spTest1()
AS
BEGIN
update "Part Master"
set "Part Master".PMDES1_01 = RTRIM("Part Master".PMDES1_01) +
REPLICATE (' ', 24 - (length(RTRIM("Part Master".PMDES1_01)))) + '~'
where "Part Master"."UDFKEY_01" ='R' OR "Part Master"."UDFKEY_01"
='RS'
AND POSITION('~', "Part Master".PMDES1_01) = 0;
END


Getting an error:
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine
Interface][Data Record Manager]General error.

Any other thoughts?

.