Naming Restrictions and Syntax Standards

Content

Naming Restrictions

Relative Date and Time

LabVantage Data Types

Naming Restrictions

Top

SDCs, SDIs, Reference Types, and Reference Values

Character Length:

Item	Column	Maximum Character Length
User SDCs	SDCId	13
User SDCs	SDI Primary Keys	40 (adjustable using the "Usable Key Size" property in the SDC Maintenance page)
System SDCs	SDI Primary Keys	40 (adjustable using the "Usable Key Size" property in the SDC Maintenance page)
Reference Types	RefTypeId	20
Reference Types	RefValueId	80

Illegal Characters:

•

Do not use these characters in the identifier:

Character	Description
'	single quote
"	double quote
[	open square bracket
]	close square bracket
{	open curly bracket
}	close curly bracket
\|	pipe
;	semicolon
\	backslash
&	ampersand

•

Do not use these words as identifiers:

all	none
current	null
date	operator
default	system
developer	startup
first	this
last

SDI Columns

When naming SDI columns you have added:

•

Do not assign column identifiers that already exist in the table.

•

We recommend that you do not assign column identifiers that already exist anywhere in the LabVantage database. Following this practice will make it easier to track your table columns and debug your queries.

•

Do not name columns using these LabVantage Core column identifiers:

auditedflag	keyid1
auditpromptflag	keyid2
auditsequence	keyid3
createby	moddt
createdt	modtool
createtool	sdcid
modby	tracelogid
	usersequence

Relative Date and Time Syntax Standards

Top

Date	Syntax	Time	Syntax
End Hour	EH	Days	D
End Month	EM	Hours	H
End Next Hour	EN	Minutes	M
End Next Month	ENM	Seconds	S
End Tomorrow	EO
End Previous Month	EPM
End Year	ER
End Today	ET
End Yesterday	EY
End Week	EW
Midday Tomorrow	MO
Midday Today	MT
Midday Yesterday	MY
Now	N
Start Hour	SH
Start Month	SM
Start Next Hour	SN
Start Next Month	SNM
Start Tomorrow	SO
Start Previous Month	SPM
Start Year	SR
Start Today	ST
Start Yesterday	SY
Start Week	SW
Today	T
Tomorrow	O
Yesterday	Y

LabVantage Data Types

Top

These LabVantage Data Types define data and determine how they are displayed.

Property Type	Syntax	Description
string	string	Common string data type for data that need not be restricted to any of the data types listed below.
sdclist_	sdclist_user	Displays the SDC you specify in a read-only select list. The syntax example at the left shows the User SDC.
sdcelist_	sdcelist_role	Displays SDCs in an editable select list. The syntax example at the left shows the Role SDC.
yesno	yesno	Displays a select list containing 'Yes' and 'No'. This returns a value of Y or N depending on the item selected.
absreldate	absreldate	Values for Absolute and Relative dates, entered according to Relative Date and Time Syntax Standards. These values are passed into the Action as displayed in the select list.
file_	file_	Displays a file selection dialog. Selecting a file assigns the complete file path to the property.
rgb	rgb	Displays a color selection dialog box. After selecting a color, a color number is assign to the property after the Action is processed. The color number is the rgb long value.
stringpassword	stringpassword	Opens a password dialog in which a user enters a password. The value is encrypted when stored.
list_{ItemList}	list_Item1;Item2	Dispays a list of items. Use a semicolon to separate each item. The syntax example at the left displays a select list containing Item1 and Item2.
elist_{ItemList}	elist_Item1;Item2	Displays an editable list of items. Use a semicolon to separate each item. The syntax example at the left displays a select list containing Item1 and Item2.
reftype_	reftype_color	Displays Reference Types in a read-only select list. The syntax example at the left shows the color Reference Type.
ereftype	reftype_hue	Displays Reference Types in an editable select list. The syntax example at the left shows the hue Reference Type.