USP_DATAFORMTEMPLATE_ADD_DAILYSALEITEMCOMBINATION_PRELOAD
The load procedure used by the edit dataform template "Daily Sale Item Combination Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESMETHODID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DAILYSALEITEMCOMBINATION_PRELOAD
(
@SALESMETHODID uniqueidentifier = null output
)
as
set nocount on;
begin try
select
@SALESMETHODID = ID
from dbo.SALESMETHOD
where TYPECODE = 0
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0;