How to create data window in power builder

Поділитися
Вставка
  • Опубліковано 15 жов 2024
  • Open DataWindow Painter:
    From the PowerBuilder IDE, go to the New option in the File menu and select DataWindow.
    Select Data Source:
    Choose the type of data source for the DataWindow (e.g., SQL Select, Stored Procedure, External, etc.).
    Click OK after selecting the data source.
    Design the SQL Query:
    For a SQL Select, write the SQL query or use the graphical query builder to select the tables and columns.
    Test the query to ensure it's correct and returns the desired data.
    Select a Presentation Style:
    Choose the presentation style for the DataWindow. PowerBuilder offers several styles such as Tabular, Freeform, Grid, Graph, etc.
    Click OK after selecting a style.
    Design the DataWindow Layout:
    In the DataWindow painter, customize the layout by adjusting column positions, adding headers, setting properties (fonts, colors), and defining sorting or filtering.
    Save the DataWindow:
    Save the DataWindow by giving it a meaningful name.
    Use DataWindow in Script:
    You can now assign the DataWindow to a DataWindow control on your window or form through scripting (e.g., dw_1.SetTransObject(SQLCA) for connection).
    This process helps you design a DataWindow visually, linking data to UI in PowerBuilder.

КОМЕНТАРІ • 3