how to use functions and views in SMP2.3

[Former Member]

Hi all,

   I am new to SUP/SMP, I did some samples for hwc like create the MBO with object queries and operations using tables. Now i have a doubt 

     Is it possible to use sql functions in smp2.3?

     If it possible how to use them?

     for Select Query can i use stored procedure?

Ex: Select * from Employee where EmpID=:empid for this querey i wrote a stored procedure like this

Create procedure Emp_sp(@empID int)

as

begin

Select * from Employee where EmpID=@empID;

end

This procedure shown in my database connections profile.

I created an  operation,

when i invoke the operation this procedure is visible in the operations list, i give the success screen in that i put a listview but here the attributes are not comming.

Is there any mistake in my approach,

Please suggest me.

Thank you.

[Jitendra_Kansal]

I will suggest you to look at official document for more understanding:

SyBooks Online