pears.NetGetSwitches

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

Original SQL

CREATE PROCEDURE "pears"."NetGetSwitches"( IN "pWebUserID" CHAR(20) ) 
RESULT( "pSwitches" CHAR(20) ) 
// IQXWeb
BEGIN
  SELECT top 1 "IQXNetSwitchID" FROM "IQXNetSwitch" WHERE "Value" = 1
END /* DOC
2017-11-07 GJ Created - Probably needs tweaking
2018-01-25 PC slightly tweaked
 
Inputs:
pWebUserID
 
Outputs:
pSwitches
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetGetSwitches" IS 
{CREATE PROCEDURE pears."NetGetSwitches"( IN pWebUserID CHAR(20) ) 
RESULT( pSwitches CHAR(20) ) 
// IQXWeb
BEGIN
    SELECT top 1 IQXNetSwitchID FROM  IQXNetSwitch WHERE VALUE=1
END
 
/* DOC
2017-11-07 GJ Created - Probably needs tweaking
2018-01-25 PC slightly tweaked
 
Inputs:
    pWebUserID
 
Outputs:
    pSwitches
 
*/
}