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 150 – PowerBuilder Library

Using Quick Select – PB Docs 150

Using Quick Select

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

proc.png 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 Chapter 19, “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