Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Using Quick Select – PB Docs 2021 – PowerBuilder Library

Using Quick Select – PB Docs 2021

Using Quick Select

The easiest way to define a data source is using Quick
Select.

To define the data using Quick Select:

  1. Click Quick Select in the Choose Data Source dialog box in the
    wizard and click Next.

  2. Select the table that you will use in the DataWindow
    object.

    For more information, see Selecting a
    table
    .

  3. Select the columns to be retrieved from the database.

    For more information, see Selecting
    columns
    .

  4. (Optional) Sort the rows before you retrieve data.

    For more information, see Specifying
    sorting criteria
    .

  5. (Optional) Select what data to retrieve.

    For more information, see Specifying
    selection criteria
    .

  6. Click the OK button in the Quick Select dialog box.

    You return to the wizard to complete the definition of the
    DataWindow object.

Quick Select limitations

When you choose Quick Select as your data source, you
cannot:

  • Specify grouping before rows are retrieved

  • Include computed columns

  • Specify retrieval arguments for the SELECT statement that are
    supplied at runtime.

To use these options when you create a DataWindow object, choose
SQL Select as your data source. If you decide later that you want to use
retrieval arguments, you can define them by modifying the data source.
For more information, see Enhancing DataWindow
Objects
.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x