====== pears.NetAudit ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Original SQL =====
create procedure "pears"."NetAudit"( in "pWebUserID" char(20),in "pActionType" char(20),in "pDescription" long varchar default null,in "pRecordID" char(20) default null )
result( "pResult" char(250) )
// IQXWeb
begin
insert into "IQXNetAuditLog"
( "IQXNetUserID","ActionType","Description","RecordID" ) values
( "pWebUserID","pActionType","pDescription","pRecordID" ) ;
select '0:~Success'
end
go
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAudit" IS
{create procedure pears.NetAudit(in pWebUserID char(20), in pActionType char(20), in pDescription long varchar default null, pRecordID char(20) default null)
result(pResult char(250))
// IQXWeb
begin
insert into IQXNetAuditLog
(IQXNetUserID, ActionType, Description, RecordID)
values
(pWebUserID, pActionType, pDescription, pRecordID);
select '0:~Success'
end
}