Description

PowerBuilder and InfoMaker provide a new DBParm parameter named DateTimeAllowed for use with any of the following database interfaces:

• MSS Microsoft SQL Server 6.x
• SYB SQL Server 4.x DB-Lib
• SYC Sybase Systems 10 and 11 CT-Lib
• SYD Sybase Systems 10 and 11 CT-Lib distributed application interface (UNIX only)
• SYT Sybase SQL Server DB-Lib (Windows NT and Windows 95 only)

When you are using one of these interfaces to access the database, DateTimeAllowed controls whether DateTime columns in your table display in the Unique Key Columns list in the Specify Update Properties dialog box. You can then select one or more columns from this list to appear in the WHERE clause of a SQL UPDATE or DELETE statement that PowerBuilder or InfoMaker generates to update the database.

By default, DateTimeAllowed is set to 0 to prohibit DateTime columns from displaying in the Unique Key Columns list and, consequently, from appearing in the WHERE clause of an UPDATE or DELETE statement. When you set DateTimeAllowed to 1, any DateTime columns in your table display in the Unique Key Columns list and can therefore be selected to appear in the WHERE clause of an UPDATE or DELETE statement.

• For more about using the Specify Update Properties dialog box, see the "Controlling updates" section in the PowerBuilder or InfoMaker User's Guide.

Purpose

Setting DateTimeAllowed to 1 enables you to specify DateTime columns as unique key columns in the WHERE clause of an UPDATE or DELETE statement when you are updating the database from a DataWindow object or form. Previously, DateTime columns did not display in the Unique Key Columns list and could not be selected to appear in the WHERE clause.

Usage

As with any other DBParm parameter, you can set DateTimeAllowed in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.

You must specify a value for DateTimeAllowed before connecting to the database in PowerBuilder or InfoMaker.