Hi everybody,
Here am i again.
One more question for you.
I read the user guide on using EXEC_SP action and i'm trying to use it with a simple query to see if it works. And it doesn't.
My Procedure:
BEGIN
select
EMPLOYEE_RID
,DATE
,year(DATE)
,month(DATE)
,WEEKDAY
,HOURS
,EXTRAHOURS
,TOTALHOURS
from bastestdomainqmd_bo_hoursheet
WHERE
EMPLOYEE_RID=F_ID
group by EMPLOYEE_RID
,DATE
,WEEKDAY;
END
MY PROCESS:
EXEC_SP 'SP_TEST' WITH '@F_ID'=10664 RETURN BO_HOURSHEET
[b]FIND ALL BO_HOURSHEET[/b]
I already tried DISPLAY 'query', but the query has the same rule FIND ALL BO_HOURSHEET
WHAT AM I DOING WRONG?
CAN SOMEONE POST AN EXAMPLE? I WOULD BE VERY THANKFUL
