Lotus Domino Designer 6.5 Help

WHAT'S NEW IN DOMINO DESIGNER 6?

@Functions
New @functions:

@AttachmentModifiedTimes returns the date on which the file attached to the current document was last modified.
@BusinessDays returns the number of business days in one or more date ranges.
@CheckFormulaSyntax checks commented out formula code for errors.
@Compare compares two lists pair-wise.
@ConfigFile returns the file path to the initialization file for the current application.
@Count returns the number of elements in a list. Unlike @Elements, which returns a zero if the value it is evaluating is a null string or not a list, @Count returns a 1, which can prevent errors from being generated in complex formulas.
@DocLock locks, unlocks, or returns the locked status of the current document.
@DocOmittedLength returns the size, in bytes, of data missing from a document that has been truncated in replication.
@DoWhile executes one or more statements iteratively while a condition remains true. Checks the condition after executing the statements.
@Eval compiles and runs each element in a text expression as a formula at run-time.
@FileDir returns the directory portion of a path name.
@FloatEq compares two numbers for equality within a confidence range.
@For executes one or more statements iteratively while a condition remains true. Checks the condition after executing the statements.
@GetAddressBooks returns a list of the address books associated with the current user or server.
@GetCurrentTimeZone returns the current operating system's time zone settings in canonical time zone format.
@GetField returns the value of a specified field. @GetField, @ThisName, and @ThisValue provide a means to write portable code. Instead of specifying field names in formulas, use these @functions to write code that can be copied as is from one formula to another.
@GetFocusTable returns the row, column, and name of the table currently in focus.
@GetHTTPHeader returns the value of an HTTP request-header field.
@GetViewInfo returns a view attribute.
@HashPassword encodes a string.
@IfError returns a null string ("") or the value of an alternative statement if a statement returns an error.
@IsNull tests for a null value.
@IsVirtualizedDirectory indicates whether virtualized directories are enabled for the current server.
@LDAPServer returns the URL and port number of the LDAP listener for the current domain.
@Nothing, in an @Transform formula, returns no list element.
@OrgDir returns the subdirectory name for the company for which the currently authenticated user is registered in an xSP environment.
@ReplicaID returns the replica ID of the current database.
@ServerAccess tests the access level that a specified user has to a server.
@ServerName returns the name of the server containing the current database.
@SetHTTPHeader sets the value of an HTTP response-header field.
@SetViewInfo filters the documents that display in a view according to criteria you specify.
@Sort sorts a list.
@StatusBar writes a message or messages to the status bar.
@ThisName returns the name of the current field.
@ThisValue returns the value of the current field.
@TimeMerge builds a time-date value from separate time, date, and time zone values.
@TimeToTextInZone converts a time-date value to a text string, including the time zone information.
@TimeZoneToText converts a canonical time zone value to a human-readable text string.
@ToNumber converts a value with a data type of text or number to a number value.
@ToTime converts a value with a data type of text or time to a date-time value.
@Transform applies a formula to each element of a list.
@UpdateFormulaContext updates the context of a formula to the Notes client window currently being accessed by the code.
@URLDecode decodes a URL string into regular text.
@URLEncode encodes a string in a URL-safe format.
@UrlQueryString returns the current URL command and parameters, or the value of one of the parameters.
@VerifyPassword compares two passwords enabling you to determine if a password has a hash or standard password format.
@WebDbName returns the database name in URL format. You no longer have to parse and replace substrings in @DbName.
@While executes one or more statements iteratively while a condition remains true. Checks the condition before executing the statements.

Enhanced @functions:

@DialogBox has a new keyword [OkCancelAtBottom].
@DbColumn (Domino data source) allows "ReCache" in the first parameter to refresh the cache where "" (cache) is specified in a previous lookup to the same data source.
@DbColumn (ODBC data source) allows "ReCache" in the first parameter to refresh the cache where "" (cache) is specified in a previous lookup to the same data source.
@DbCommand(Domino data source) enables you to list folders and display next or previous groups of documents in a view. This function works in Web applications only.
@DbCommand (ODBC data source) allows "ReCache" in the first parameter to refresh the cache where "" (cache) is specified in a previous lookup to the same data source.
@DbLookup (Domino data source) allows the keywords [FailSilent], [PartialMatch], and [ReturnDocumentUniqueID] as a new parameter.
@DbLookup (Domino data source) allows "ReCache" in the first parameter to refresh the cache where "" (cache) is specified in a previous lookup to the same data source.
@DbLookup (ODBC data source) allows "ReCache" in the first parameter to refresh the cache where "" (cache) is specified in a previous lookup to the same data source.
@Explode takes a fourth parameter that permits the suppression of newlines as separators. Not previously documented is the fact that newlines are treated as separators regardless of the specification of the second parameter.
@Max with one parameter returns the largest number in a list.
@Min with one parameter returns the smallest number in a list.
@Name has new keywords that convert a name from Domino to LDAP format and vice-versa.
@Now takes parameters that allow the time-date to be based on the server containing the current database or specified servers.
@SetDocField can now be used to set the value of a field in the current document.
@Text converts rich text.
@UserAccess accepts keyword parameters that can return the user's database access level or test for specific user privileges for a database.

Glossary

Help on Help

Open Full Help Window

Glossary

Help on Help

Open Full Help Window