• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

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?


0
basilhs_s
Asked:
basilhs_s
  • 3
1 Solution
 
diasroshanCommented:
Hi,

Which version of PB are u using.
Try to export the DW and add the column in the SQL and other related attributes.
Then import it.

It should work.

If u cant manage it, export the DW and paste it here.

Cheers,
Rosh
0
 
basilhs_sAuthor Commented:
i am using powerbuilder 10.0. i will do what you mentioned and let you know.
0
 
basilhs_sAuthor Commented:
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?
0
 
basilhs_sAuthor Commented:
thanks
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now