AdsSQLServer Properties

A string representing the alias of the work area.

A symbol representing the alias of a DBServer object.

A logical value indicating whether the server is positioned at the beginning of the file, on the first record.

**Missing documentation **

A constant, identifying the mode of automatic concurrency control for this data server, determining when and how records are locked and released:

An array containing the structure of this data server, whose length (that is, number of elements) is equal to the number of fields in the server.

Return the original dbstructure array from the DbServer object.

A logical value indicating whether the current record is marked as deleted.

A string representing the name of the database driver in use with this server.

A logical value indicating whether the server is positioned at the end of the file, on the last record

An Error object identifying the error condition after the last operation.

Returns the internal ErrorInfo object, regardless of the last operation produced an error or not.

The number of fields in the server.

This returns an empty array. For servers that were painted in the DbServer editor this returns the array of DataFields.

The FileSpec object that defines the path and file name of the DBF file.

A string representing the current active filter.

The "FOR block" component of the "general server scope," which affects several bulk processing methods if they are called with no explicit scope.

A logical value indicating whether the previous search operation succeeded.

A numeric value representing the length of the database file header.

**Missing documentation **

The hyperlabel connected to this data server. From the hyperlabel, you can retrieve additional information about the data server

A string representing the default index extension based on the database driver currently linked (for example, ".NTX" for the DBFNTX driver).

This returns an empty array. For servers that were painted in the DbServer editor this returns the array of Indexes.

The number of records in the current database file.

The last modification date of the DBF file used in the server.

This returns the memo extension of the file (if any). For example DBT or FPT.

This returns the name of the DbServer.

A symbol representing the name of this data server.

This returns the OLE extension of the file (if any). For example DFL.

A key value representing the record of the bottom boundary in the range of key values that will be included in the controlling order's current scope.

The key value of the current record from the controlling order.

A key value representing the record of the top boundary in the range of key values that will be included in the controlling order's current scope.

This returns a DBSTRUCT array based on the DataFields and Fieldspecs that were painter in the server editor.

A string representing the name of the database driver in use with this server.

This returns the list of RDDs that were passed to the DbServer constructor.

A logical value indicating whether the file was opened as a read-only file. This is determined by an instantiation parameter of the server.

The number of records in the current database file.

A numeric value representing the current record number, identifying the position of the record pointer.

A numeric value representing the record length of the server in bytes.

The returns the array of children that were registered with SetRelation()

The setting that determines how often the DbServer object should retry operations that fail.

An array of record numbers that are currently locked.

The "scope" component of the "general server scope," which affects several bulk processing methods if they are called with no explicit scope. The initial value of the scope is NIL.

The workarea number of the parent area when the dbserver is a child in a relation.

A logical value indicating whether the server is sharable or exclusive.

A HyperLabel object identifying the status after the last operation. If

Return the Extension for the opened DBF. This is normally .DBF but may be different if a file with a different extension was opened.

A logical value indicating whether the server is currently open

The "WHILE block" component of the "general server scope," which affects several bulk processing methods if they are called with no explicit scope

A number representing the workarea of the server