powerbuilder , stored procedure

Posted on 2009-02-11
Last Modified: 2013-12-26
i created a stored procedure in sql server 2000 as follows
create procedure sp_test
@scr_name                 nvarchar(100)
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?

Question by:basilhs_s
    LVL 18

    Accepted Solution


    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.


    Author Comment

    i am using powerbuilder 10.0. i will do what you mentioned and let you know.

    Author Comment

    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?

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
    Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now