DataWindow data sources

Supported

The following PowerBuilder data sources are supported:

  • Quick Select

  • SQL Select

  • Query

  • Stored Procedure

  • External

  • Web Service

Notes:

  1. You can group your stored procedure in ASE Server.

  2. If a DataWindow uses an external data source, the content of the DataWindow can only be saved as TXT type.

  3. In the Web Service DataWindow, if the date data is empty or null, it will return a default value "0001-1-1" which will be parsed as "2001-1-1" on mobile, whereas parsed as "0001-1-1" in PowerBuilder.

  4. The Web Service DataWindow supports the Boolean, Byte, Char, Date, DateTime, Decimal, Double, Integer, Long, String, and Time data types and array, but does not support the Blob data type, pass by reference, and structure.

Unsupported

  • Dynamically changing the SQL statement of an external data source is unsupported.

  • If a DataWindow uses a stored procedure as its data source and the stored procedure has multiple result sets, the deployed DataWindow always takes the first result set.

  • If a DataWindow uses a stored procedure as its data source, the Table.Select property cannot be modified, and the SetSQLSelect function cannot be executed.

  • If a DataWindow uses an ASE stored procedure as its data source, the AutoCommit property must be set to TRUE and the chain must be off.