Special property values

There are some properties where values appear on project design differently from the values that you must provide in a parameter set.


Check boxes

For properties represented by a check box on project design, you must provide 0 (deactivated) or 1 (activated) as the value in a parameter set.


Expressions

To use dynamic values in a parameter set, enter SBN expressions in the same way as in the Design window. The Eval column indicates whether a property is enabled for expressions. See “Square Bracket Notation”.

You especially need expressions when setting values containing nonprinting characters, such as, Tab, CRLF, and so on. You must set the Evaluate option for these properties when designing the project.

NoteYou cannot validate expressions in the Parameter Set window.


Drop-down menus

Some menus do not display the underlying parameter value. Some of these values require you to set the Evaluate option to assign them via a parameter set.

Use this table to identify which value (Value) corresponds to the displayed one (Prompt) and whether you must enable Evaluate.

Component

Property

Prompt

Value

Evaluate

DB components

Interface

ODBC

dbodbc

Sybase

dbsybase

Oracle

dboracle

IBM DB/2

dbdb2

SQLite Persistent

dbpersistent

OLE DB

dbole

Text components

Row Delimiter

Position

LF

[uChr(10)]

x

CR

[uChr(13)]

x

CRLF

[uConcat(uChr(13),uChr(10))]

x

Column Delimiter

Position

Tab

[uChr(9)]

x

Comma

,

Semicolon

;

Column Quote

None

Single Quote

'

Double Quote

"