Deletes a substitution variable.
Syntax
ESS_FUNC_M EssDeleteVariable (hCtx, pVariable);
Parameter | Data Type | Description |
---|---|---|
hCtx | ESS_HCTX_T | Context handle to the API. |
pVariable | ESS_VARIABLE_T | The pointer to the structure containing the description of the substitution variable being deleted. |
Return Value
If successful, returns zero.
Example
/* ** ESS_DeleteVariable() deletes a substitution variable using ** the API EssDeleteVariable. */ ESS_FUNC_M ESS_DeleteVariable (ESS_HCTX_T hCtx) { ESS_FUNC_M sts = ESS_STS_NOERR; ESS_VARIABLE_T Variable; ESS_PVARIABLE_T pVariables; ESS_ULONG_T ulCount, i; printf("\n ******************************************"); printf("\n **** An example of using EssDeleteVariable"); printf("\n ******************************************"); strcpy(Variable.VarName, "QuarterName"); strcpy(Variable.Server, "Local"); strcpy(Variable.AppName, "Sample"); strcpy(Variable.DbName, "Basic"); sts = EssDeleteVariable(hCtx, &Variable); if (sts == ESS_STS_NOERR) printf("\n Variable 'QuarterName' at the Server/App/Db level is deleted"); if (sts == ESS_STS_NOERR) { strcpy(Variable.VarName, "MarketName"); strcpy(Variable.Server, "Local"); strcpy(Variable.AppName, "Sample"); strcpy(Variable.DbName, ""); sts = EssDeleteVariable(hCtx, &Variable); if (sts == ESS_STS_NOERR) printf("\n Variable 'MarketName' at the Server/App level is deleted"); } if (sts == ESS_STS_NOERR) { strcpy(Variable.VarName, "MarketName"); strcpy(Variable.Server, "Local"); strcpy(Variable.AppName, ""); strcpy(Variable.DbName, ""); sts = EssDeleteVariable(hCtx, &Variable); if (sts == ESS_STS_NOERR) printf("\n Variable 'MarketName' at the Server level is deleted"); } /*********************************************************/ /* List the variables at the level of the Server/App/Db- */ /* We should not have any */ /*********************************************************/ if (sts == ESS_STS_NOERR) { strcpy(Variable.Server, "local"); strcpy(Variable.AppName, "Sample"); strcpy(Variable.DbName, "Basic"); sts = EssListVariables(hCtx, &Variable, &ulCount, &pVariables); if (sts == ESS_STS_NOERR) { printf("\n--- Number of Substitution Variables at the Server, App and Db level is: %ld\n", ulCount); for (i = 0; i < ulCount; i++) { printf("Variable name : %s\n", pVariables[i].VarName); printf("Server name : %s\n", pVariables[i].Server); printf("Application name : %s\n", pVariables[i].AppName); printf("Database name : %s\n", pVariables[i].DbName); printf("Variable value : %s\n\n", pVariables[i].VarValue); } } } /*********************************************************/ /* List the variables - at the level of the App */ /*********************************************************/ if (sts == ESS_STS_NOERR) { strcpy(Variable.Server, "local"); strcpy(Variable.AppName, "Sample"); strcpy(Variable.DbName, ""); sts = EssListVariables(hCtx, &Variable, &ulCount, &pVariables); if (sts == ESS_STS_NOERR) { printf("\n--- Number of Substitution Variables at the Server and App level is: %ld\n", ulCount); for (i = 0; i < ulCount; i++) { printf("Variable name : %s\n", pVariables[i].VarName); printf("Server name : %s\n", pVariables[i].Server); printf("Application name : %s\n", pVariables[i].AppName); printf("Database name : %s\n", pVariables[i].DbName); printf("Variable value : %s\n\n", pVariables[i].VarValue); } } } /*********************************************************/ /* List variables at the server level */ /*********************************************************/ if (sts == ESS_STS_NOERR) { strcpy(Variable.Server, "local"); strcpy(Variable.AppName, ""); strcpy(Variable.DbName, ""); sts = EssListVariables(hCtx, &Variable, &ulCount, &pVariables); if (sts == ESS_STS_NOERR) { printf("\n--- Number of Substitution Variables at the Server level is: %ld\n", ulCount); for (i = 0; i < ulCount; i++) { printf("Variable name : %s\n", pVariables[i].VarName); printf("Server name : %s\n", pVariables[i].Server); printf("Application name : %s\n", pVariables[i].AppName); printf("Database name : %s\n", pVariables[i].DbName); printf("Variable value : %s\n\n", pVariables[i].VarValue); } } } if (sts == ESS_STS_NOERR) printf("\n --> No Errors in EssDeleteVariable\n\n\n"); else printf("\n --> Error in EssDeleteVariable number: %d\n\n\n", sts); return (sts); } /* end ESS_DeleteVariable */
Output
****************************************** **** An example of using EssDeleteVariable ****************************************** Variable 'QuarterName' at the Server/App/Db level is deleted Variable 'MarketName' at the Server/App level is deleted Variable 'MarketName' at the Server level is deleted --- Number of Substitution Variables at the Server, App and Db level is: 0 --- Number of Substitution Variables at the Server and App level is: 0 --- Number of Substitution Variables at the Server level is: 0 --> No Errors in EssDeleteVariable
See Also