Arguments

Description

The retrieval arguments required by the data source. You specify retrieval arguments in the DataWindow’s SELECT statement and you provide values for the retrieval arguments when you call the Retrieve method.

Applies to

Database table for the DataWindow object

Not settable in PowerScript. Used in DataWindow syntax.

Syntax

Table(Arguments = ( (name1, type), (name2, type) ... ) ... )

Parameter

Description

name

The name of the retrieval argument

type

The type of the argument:

  • Date or a Date list

  • DateTime or a DateTime list

  • Number or a Number list

  • String or a String list

  • Time or a Time list

Usage


In the painter

Set the value in the SQL Select painter or Query painter.

Open the SQL Select painter by selecting Design>Data Source from the menu bar in the DataWindow painter, or create or open a query in the Query painter. Then select Design>Retrieval Arguments.