basilhs_s
asked on
powerbuilder , stored procedure
i created a stored procedure in sql server 2000 as follows
--------------------------
create procedure sp_test
@scr_name nvarchar(100)
as
select mp1_code_ph, mp1_name from fmpel1 where mp1_name like @scr_name
--------------------------
when i try to design a datawindow (dw_cust) which will use this stored procedure as retrieve method, powerbuilder recognizes the argument and puts the two columns that exist in the select statement and 2 labels with their names in the datawindow area. so far everything is ok. i noticed the following situation
1) sql button (near to sort or filter button) seems deactivated
2) suppose that i change the select inside the stored procedure to use one more column f.e
--------------------------
select mp1_code_ph, mp1_name, mp1_phone_no from fmpel1 where mp1_name like @scr_name
--------------------------
how can i force the data window to include the additional field without designing it from scratch?
--------------------------
create procedure sp_test
@scr_name nvarchar(100)
as
select mp1_code_ph, mp1_name from fmpel1 where mp1_name like @scr_name
--------------------------
when i try to design a datawindow (dw_cust) which will use this stored procedure as retrieve method, powerbuilder recognizes the argument and puts the two columns that exist in the select statement and 2 labels with their names in the datawindow area. so far everything is ok. i noticed the following situation
1) sql button (near to sort or filter button) seems deactivated
2) suppose that i change the select inside the stored procedure to use one more column f.e
--------------------------
select mp1_code_ph, mp1_name, mp1_phone_no from fmpel1 where mp1_name like @scr_name
--------------------------
how can i force the data window to include the additional field without designing it from scratch?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i tried what you mentioned and i inserted the new field as you said (thru edit source). i suppose that i would do something similar if i am going to change something in the arguments. does powerbuilder 11 treat stored procedures with a more efficient way?
ASKER
thanks
ASKER