pears.WPKTrackChange

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL

CREATE PROCEDURE "pears"."WPKTrackChange"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "sTrackerType" CHAR(1),IN "sTrackerID" CHAR(50) ) 
BEGIN
  IF "strackertype" IS NULL OR "strackerid" IS NULL THEN
    RETURN
  END IF;
  IF "left"("strackerid",1) = '#' THEN
    SET "strackerid" = "right"("strackerid","length"("strackerid")-1)
  END IF;
  IF EXISTS(SELECT "wpkchangetrackerid" FROM "wpkchangetracker" WHERE "wpkchangetrackertype" = "strackertype" AND "wpkchangetrackerid" = "strackerid") THEN
    UPDATE "wpkchangetracker" SET "clickcount" = (IF "clickcount" between-2 and-1 THEN 1 ELSE "clickcount"+1 endif) WHERE "wpkchangetrackertype" = "strackertype" AND "wpkchangetrackerid" = "strackerid"
  ELSE
    INSERT INTO "wpkchangetracker"( "wpkchangetrackertype","wpkchangetrackerid","clickcount" ) VALUES( "strackertype","strackerid",1 ) 
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."WPKTrackChange" IS 
{CREATE PROCEDURE WPKTrackChange 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN sTrackerType CHAR(1),IN sTrackerID CHAR(50))
BEGIN
  IF strackertype IS NULL OR strackerid IS NULL THEN
    RETURN
  END IF;
  IF LEFT(strackerid,1)='#' THEN
    SET strackerid=RIGHT(strackerid,LENGTH(strackerid)-1)
  END IF;
  IF EXISTS(SELECT wpkchangetrackerid FROM wpkchangetracker WHERE wpkchangetrackertype = strackertype AND wpkchangetrackerid = strackerid) THEN
    UPDATE wpkchangetracker SET clickcount = (IF clickcount BETWEEN -2 AND -1 THEN 1 ELSE clickcount+1 endif) WHERE wpkchangetrackertype = strackertype AND wpkchangetrackerid = strackerid
  ELSE
    INSERT INTO wpkchangetracker(wpkchangetrackertype,wpkchangetrackerid,clickcount) VALUES (strackertype,strackerid,1)
  END IF
END
}