Hello Support,
I have the following Problem.
I must use the result of a stored Procedure.
I have set up a db with the required structure and can generate the basic code. So far so good, now to the Problem.
Where must I replace the Standard results in PHPR with the returned result from the stored procedure to be able to display it on the list page. Up till now I either get an SQL error or nothing is displayed.
Can I call the Procedure in an event and return the result so that it will be used instead of the standard results from PHPR, for example here from the _list.php code?
[codebox]if(CheckSecurity(@$SESSION["".$strTableName."_OwnerID"],"Search"))
{
$strSQLbak = $strSQL;
if(function_exists("BeforeQueryList"))
BeforeQueryList($strSQL,$strWhereClause,$strOrderBy);
// Rebuild SQL if needed
$strSQL =("EXEC[sp_iDeb_All_OP] 'All', 'ALL', 'ALL' ");
if($strSQL!=$strSQLbak)
{
// changed $strSQL - old style
$numrows=GetRowCount($strSQL);
}[/codebox]