AdsSQLServer Methods |
The AdsSQLServer type exposes the following members.
Name | Description | |
---|---|---|
Append |
Append a blank record to the end of this data server (the new record becomes the current position and is ready for assignment of data values).
(Inherited from DataServer.) | |
Append(Usual) |
Append a blank record to the table; this blank record becomes the current position and is ready for assignment of data values. The record is automatically locked if the Append() method returns TRUE.
(Inherited from DbServer.) | |
AppendDB |
Append new records to the table from another DBF file.
(Inherited from DbServer.) | |
AppendDelimited |
Append new records to the table from a delimited file, such as the "comma-separated-value" (CSV) file format.
(Inherited from DbServer.) | |
AppendSDF |
Append new records to the table from an SDF-formatted file.
(Inherited from DbServer.) | |
AsString |
Return the descriptive label defined for this data server.
(Inherited from DataServer.) | |
Average |
Calculate the average of a series of numeric expressions, based on the number of actual records involved.
(Inherited from DbServer.) | |
BLOBDirectExport |
Export the contents of a binary large object (BLOB) pointer to a file.
(Inherited from DbServer.) | |
BLOBDirectGet |
Retrieve data stored in a BLOB file without referencing a specific field.
(Inherited from DbServer.) | |
BLOBDirectImport |
Import a file into a BLOB file and return a pointer to the data.
(Inherited from DbServer.) | |
BLOBDirectPut |
Put data in a BLOB file without referencing a specific field.
(Inherited from DbServer.) | |
BLOBExport |
Copy the contents of a BLOB, identified by its memo field number, to a file.
(Inherited from DbServer.) | |
BLOBGet |
Get the contents of a BLOB, identified by its memo field number.
(Inherited from DbServer.) | |
BLOBImport |
Read the contents of a file as a BLOB, identified by a memo field number.
(Inherited from DbServer.) | |
BLOBRootGet |
Retrieve the data from the root area of a BLOB file.
(Inherited from DbServer.) | |
BLOBRootLock |
Obtain a lock on the root area of a BLOB file.
(Inherited from DbServer.) | |
BLOBRootPut |
Store data in the root area of a BLOB file.
(Inherited from DbServer.) | |
BLOBRootUnlock |
Release the lock on a BLOB file's root area.
(Inherited from DbServer.) | |
ClearFilter |
Clear a filter condition specified with the DBServer:SetFilter() method.
(Inherited from DbServer.) | |
ClearIndex |
Clear all indexes currently associated with the server.
(Inherited from DbServer.) | |
ClearLocate |
Clear the LOCATE condition of the server, if any.
(Inherited from DbServer.) | |
ClearOrderScope |
Set or clear the boundaries for scoping key values in the controlling order.
(Inherited from DbServer.) | |
ClearRelation |
Clear all active relations held by this server to other servers.
(Inherited from DbServer.) | |
ClearScope |
Clear the settings that define the default scope for multi-record operations.
(Inherited from DbServer.) | |
Close |
Close the database file and its associated index files.
(Inherited from DbServer.) | |
Commit |
Commit all changes to disk from the buffer, ensuring that all buffers are flushed.
(Inherited from DbServer.) | |
ConstructUniqueAlias | Create a unique alias based on the filename and an optional numeric suffix (Inherited from DbServer.) | |
Continue |
Resume a pending DBServer:Locate() operation, searching for the next record that matches (like the DBContinue() function).
(Inherited from DbServer.) | |
CopyDB |
Copy records to another DBF file.
(Inherited from DbServer.) | |
CopyDelimited |
Copy records to a delimited file.
(Inherited from DbServer.) | |
CopySDF |
Copy records to an SDF file.
(Inherited from DbServer.) | |
CopyStructure |
Create a DBF file with the same record layout as the server object to which the message is sent.
(Inherited from DbServer.) | |
Count |
Return the number of records that match a specified scope.
(Inherited from DbServer.) | |
CreateIndex |
Create an index file with an order in it.
(Inherited from DbServer.) | |
CreateOrder |
Create an order within an existing index file. The behavior depends on which driver is used.
(Inherited from DbServer.) | |
DataField |
Retrieve the data field object at the specified field position.
(Inherited from DbServer.) | |
Delete |
Delete the current record in this data server.
(Inherited from DataServer.) | |
Delete(Usual, Usual, Usual) |
Delete the current record or the records specified with the scoping parameters.
(Inherited from DbServer.) | |
DeleteAll |
Delete all records of the table.
(Inherited from DbServer.) | |
DeleteOrder |
Delete an order from an index file.
(Inherited from DbServer.) | |
Error |
Provide a method for handling error conditions raised during database processing.
(Inherited from DbServer.) | |
Eval |
Evaluate a code block for each record matching a scope and condition. If neither conditions nor scope is passed to the method, it is subject to the general server scope.
(Inherited from DbServer.) | |
FIELDGET |
Get the contents of a field that is identified by its position.
(Inherited from DbServer.) | |
FieldGetBytes |
Read an array of bytes direct from the workarea buffer.
(Inherited from DbServer.) | |
FieldGetFormatted |
Return the contents of a specified field according to the formatting specifications of its FieldSpec object.
(Inherited from DbServer.) | |
FieldHyperLabel |
Return the hyperlabel of a specified field.
(Inherited from DbServer.) | |
FieldInfo |
Return and optionally change information about a field.
(Inherited from DbServer.) | |
FieldName |
Return the name of a specified field as a string.
(Inherited from DbServer.) | |
FieldPos |
Return the position of a specified field within the data server, as a number starting with 1.
(Inherited from DbServer.) | |
FIELDPUT |
Set the value of a field identified by its position.
(Inherited from DbServer.) | |
FieldPutBytes | Write an array of bytes direct to the workarea buffer. (Inherited from DbServer.) | |
FieldSpec |
Return the FieldSpec object in the specified field.
(Inherited from DbServer.) | |
FieldStatus |
Return the status of a field after the last operation.
(Inherited from DbServer.) | |
FieldSym |
Return the name of a specified field.
(Inherited from DbServer.) | |
FieldValidate |
Perform all the validations defined to the FieldSpec object of a field (for example, required, maximum and minimum digits, maximum and minimum value, validation rule) and return the result of the test.
(Inherited from DbServer.) | |
FLOCK |
Lock the table used by this server for exclusive access.
(Inherited from DbServer.) | |
GetArray |
Retrieve an array of values from a field in the server, subject to the currently active selection, if any.
(Inherited from DbServer.) | |
GetLocate |
Retrieve the code block of the current LOCATE condition, or NIL if no code block is set.
(Inherited from DbServer.) | |
GetLookupTable |
Retrieve a two-column array of values from two fields in the server, subject to the currently active selection, if any.
(Inherited from DbServer.) | |
GoBottom |
Position the data server at the last record.
(Inherited from DbServer.) | |
GoTo |
Position the data server at a specified record number.
(Inherited from DbServer.) | |
GoTop |
Position the data server at the first record.
(Inherited from DbServer.) | |
INDEXKEY |
Return the key expression of a specified single-order index.
(Inherited from DbServer.) | |
INDEXORD |
Return the ordinal position of the controlling order in the order list. (Similar to the IndexOrd() function.)
(Inherited from DbServer.) | |
Info |
Return and optionally change information about a data server.
(Inherited from DbServer.) | |
Join |
Join this DBServer object with another DBServer object and place the results in the file specified.
(Inherited from DbServer.) | |
Locate |
Search sequentially for a record matching a condition. If neither conditions nor scope is passed to the method, it is subject to the general server scope.
(Inherited from DbServer.) | |
LockCurrentRecord |
Lock the current record. This method is identical to invoking RLock() with the current record number as a parameter.
(Inherited from DbServer.) | |
LockSelection |
Lock all the records in the currently active selection.
(Inherited from DbServer.) | |
NoIVarGet |
Provide a general error interception that is automatically called (in any class) whenever an access reference is made to a non-existent exported instance variable. In the DBServer class, it is used to implement the virtual field variable.
(Inherited from DbServer.)Important! NoIVarGet() should not be called directly; it is called by the system for handling invalid references. | |
NoIVarPut |
Provide a general error interception that is automatically called (in any class) whenever an assignment reference is made to a non-existent exported instance variable. In the DBServer class, it is used to implement the virtual field variable.
(Inherited from DbServer.)Important! NoIVarPut() should not be called directly; it is called by the system for handling invalid references. | |
Notify |
An event handler that responds to events that have occurred in methods of this server, or in other servers that are linked to this server in some way. The standard implementation notifies all the server's clients of the event.
(Inherited from DbServer.)Important! This method is automatically called by the various action methods of the data server, and should normally not be called by application code. | |
OrderDescend |
Return and optionally change the descending flag of an order.
(Inherited from DbServer.) | |
OrderInfo |
Return and optionally change information about orders and index files.
(Inherited from DbServer.) | |
OrderIsUnique |
Return the status of the unique flag for a given order.
(Inherited from DbServer.) | |
OrderKeyAdd |
Add a key to a custom built order.
(Inherited from DbServer.) | |
OrderKeyCount |
Return the number of keys in an order.
(Inherited from DbServer.) | |
OrderKeyDel |
Delete a key from a custom built order.
(Inherited from DbServer.) | |
OrderKeyGoTo |
Move to a record specified by its logical record number in the controlling order.
(Inherited from DbServer.) | |
OrderKeyNo |
Get the logical record number of the current record.
(Inherited from DbServer.) | |
OrderScope |
Set the boundaries for scoping key values in the controlling order.
(Inherited from DbServer.) | |
OrderSkipUnique |
Move the record pointer to the next or previous unique key in the controlling order.
(Inherited from DbServer.) | |
Pack |
Remove deleted records from a database file.
(Inherited from DbServer.) | |
PostInit |
Implement customized initialization code for the window.
(Inherited from DataServer.) | |
PreInit |
Implement customized initialization code for the server.
(Inherited from DataServer.) | |
RDDINFO |
Return and optionally change settings controlled directly by the RDD.
(Inherited from DbServer.) | |
Recall |
Recall those deleted records indicated by a specified scope.
(Inherited from DbServer.) | |
RecallAll |
Recall all deleted records in the table.
(Inherited from DbServer.) | |
RecordInfo |
Retrieve information about the indicated record.
(Inherited from DbServer.) | |
Refresh |
Reread the current record from the database, discarding any changes that have been made.
(Inherited from DbServer.) | |
Refresh(Usual) |
Requery the SQL statement
| |
RegisterClient |
Register an object as a client of this data server, so that it receives notification messages from the server about certain actions.
(Inherited from DataServer.) | |
Reindex |
Recreate all active indexes for this server.
(Inherited from DbServer.) | |
Relation |
Return the linking expression of a specified relation.
(Inherited from DbServer.) | |
Replace |
Replace one or several fields with a new expression, for all records that match a specified scope.
(Inherited from DbServer.) | |
ResetNotification |
Resume the broadcasting of Notify messages to the server's attached clients (after DBServer:SuspendNotification() has been called).
(Inherited from DbServer.) | |
RLOCK |
Lock a record for exclusive write access; other users can still make read-only reference to the record.
(Inherited from DbServer.) | |
RLockVerify |
Determine if the current record in this data server has any pending updates and lock it for exclusive write access if there are none.
(Inherited from DbServer.) | |
Rollback |
Undo the changes made to this data server within the current transaction.
(Inherited from DataServer.) | |
Seek(Usual) |
Move to the next record having a specified key value in the controlling order.
(Inherited from DataServer.) | |
Seek(Usual, Usual, Usual) |
Move to the record having the specified key value in the controlling order.
(Inherited from DbServer.) | |
SELECT | Select the workarea that the DbServer uses. (Inherited from DbServer.) | |
SetDataField |
Assign a DataField object to a specified field.
(Inherited from DbServer.) | |
SetFilter |
Set a filter condition.
(Inherited from DbServer.) | |
SetIndex |
Open an index file and select its order as the controlling order, if this is the first index being opened.
(Inherited from DbServer.) | |
SetOrder |
Select an order from one of the open index files as the controlling order.
(Inherited from DbServer.) | |
SetOrderCondition |
Set conditions that is applied to index and order creation. If SetOrderCondition() has not been called, order creation is subject to the general server scope. If neither has been set, orders are not conditional.
(Inherited from DbServer.) | |
SetRelation |
Set a relation from this server to the child server.
(Inherited from DbServer.) | |
SetSelectiveRelation |
Set a selective relation from this server to the child server; standard database operations are restricted to those records that match the relation.
(Inherited from DbServer.) | |
Skip |
Move the record pointer forward or backward a specified number of records.
(Inherited from DbServer.) | |
Sort |
Copy records to another database file in sorted order. If neither conditions nor scope is passed to the method, it is subject to the general server scope.
(Inherited from DbServer.) | |
Sum |
Calculate the sum of a series of numeric expressions.
(Inherited from DbServer.) | |
SuspendNotification |
Suspend the broadcasting of Notify messages to the server's attached clients.
(Inherited from DbServer.) | |
Total |
Aggregate records by key value, producing grouped summarizations, and write the aggregate records to another database.
(Inherited from DbServer.) | |
UnLock |
Remove all locks held on this data server.
(Inherited from DataServer.) | |
UnLock(Usual) |
Release a specified lock or all locks.
(Inherited from DbServer.) | |
UnRegisterClient |
Remove the registration of an object as a client of this data server, so that it no longer receives notification messages from the server about certain actions.
(Inherited from DataServer.) | |
Update |
Update this server with data from another server or table.
(Inherited from DataServer.) | |
Update(Usual, Usual, Usual, Usual) |
Update this server with data from another server or table.
(Inherited from DbServer.) | |
Zap |
Permanently remove all records from the server and release the disk space.
(Inherited from DbServer.) |