Special property values

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

Check boxes

For properties represented by a checkbox on project design, you must provide 0 (deactivated) or 1 (activated) as the value.

Expressions

To use variable values in a parameter set, enter 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 non-printing characters, such as, Tab, CRLF, and so on. You must set the Evaluate option for these properties when designing the project.

Expressions cannot be validated 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	"