In the previous example, we use ('1996/07/01', '1996/07/21') as parameters. You might want to change parameters of a stored procedure to get different data at runtime. The Cicode example below shows you how to do this. Assume that the control occupies at “AN35” on the graphics page.
FUNCTION GetSelectedData(STRING sStartDate,STRING sEndDate)
STRING sParameters;
sParameters ="('"+ sStartDate +"','"+ sEndDate +"')";
_ObjectSetProperty(ObjectByName("AN35"), "StoredProcArgs",sParameters);
_ObjectCallMethod(ObjectByName("AN35"), "Refresh");
END
To change the parameters of a stored procedure at runtime:
GetSelectedData(DATE_1, DATE_2)
Notes