Run stored proc on button, pass int and boolean in strored proc

Hi all

1.) is there any way to just excecute stored proc on button script, i dont need an information link.

2.) i am currently using below stript to run stored proc, is ther any way to pass integer parameter in below script. i need 'a' as int and 'd' as boolean in below as int, becasue int in DB proc.

 

from System import Array,Guid,String,Object
from Spotfire.Dxp.Data.Import import InformationLinkDataSource, InformationLinkParameter
from Spotfire.Dxp.Data import *

UpdateContent=1
print Parameter

a=Array.CreateInstance(str,1)
a[0]=UpdateContent

Group=Document.Properties["DynamicGroup"]
b=Array.CreateInstance(str,1)
b[0]=Group

c=Array.CreateInstance(str,1)
c[0]=Key

d=Array.CreateInstance(str,1)
d[0]=Document.Properties["NewGroup"]

ilParam1 = InformationLinkParameter.CreateReferencedParameter(Guid("6fd8732e-39f0-46be-ada5-285a930ca687"),"@UpdateContent",a)
ilParam2 = InformationLinkParameter.CreateReferencedParameter(Guid("6fd8732e-39f0-46be-ada5-285a930ca687"),"@Key",b)
ilParam3 = InformationLinkParameter.CreateReferencedParameter(Guid("6fd8732e-39f0-46be-ada5-285a930ca687"),"@DimKeys",c)
ilParam4 = InformationLinkParameter.CreateReferencedParameter(Guid("6fd8732e-39f0-46be-ada5-285a930ca687"),"@Name",d)

ilDataSource = InformationLinkDataSource("a0f2b722-5b53-4f35-b14b-0d446da28b42", [ilParam1],[ilParam1],[ilParam1],[ilParam1])
    
 

(1) Answer

Login