====== pears.IQXNetRequestAction ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create procedure "pears"."IQXNetRequestAction"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "pWebUserID" char(20),in "pActionType" char(50),in "pTargetType" char(20),in "pTargetID" char(20) ) begin insert into "IQXNetAction"( "IQXNetActionID","IQXNetUserID","ActionType","TargetType","TargetID","ActionState","WhenRequested" ) values ( "uniquekey"("pActionType"+"pTargetType"+"pTargetID"),"pWebUserID","pActionType","pTargetType","pTargetID",'0',current timestamp ) end go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXNetRequestAction" IS {create procedure IQXNetRequestAction /* Application Maintained Function / Procedure - DO NOT EDIT*/ (in pWebUserID char(20),in pActionType char(50),in pTargetType char(20),in pTargetID char(20)) begin insert into IQXNetAction( IQXNetActionID,IQXNetUserID,ActionType,TargetType,TargetID,ActionState,WhenRequested) values( uniquekey(pActionType+pTargetType+pTargetID),pWebUserID,pActionType,pTargetType,pTargetID,'0',current timestamp) end }