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.

You 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	"