NexusDB and PascalScript Reference
The following lists contain objects, components, methods, key words, constants, etc. which I have found to be available for use in PascalScripts with nxServer.
Of course the NexusDB components are well catered for by the PascalScript runtime compiler.
I will try to keep this updated as I find more and/or remember to add more.
Of course the NexusDB components are well catered for by the PascalScript runtime compiler.
I will try to keep this updated as I find more and/or remember to add more.
NexusDB Reserved Variables Which Can Be Called Within A WebScript
- ServerEngine - this is the server engine of the hosting nxServer
NexusDB units
- nxdb
- Constant(s)
- nxDefaultFilterTimeout: LongInt = 500
- nxMaxBlobChunk: Integer = 512 * 1024
- Type(s)
- TnxLoginEvent: Procedure(aSender: TnxBaseSession; var aUserName: String; var aPassword: String; var aResult: Boolean)
- TnxServerFilterTimeoutEvent: Procedure(Sender: TnxDataset; var Cencel: Boolean)
- TnxDataSetInternalState: (disClosing, disShutdownFromCursor, disIndexInvalid)
- TnxDataSetInternalStates: set of TnxDataSetInternalState
- TnxDataSetOption: (dsoOptimisticLocks, dsoAddKeyAsVariantField, dsoRecNoSupport)
- TnxDataSetOptions: set of TnxDataSetOption
- TnxFilterType: (ftSimple, ftSqlWhere)
- TnxKeyIndex: (kiLookup, kiRangeStart, kiRangeEnd, kiCurRangeStart, kiCurRangeEnd, kiSave)
- TnxKeyBuffer
record
kbModified: Boolean;
kbExclusive: Boolean;
kbFieldCount: Integer;
kbPartialLen: Integer;
end - TnxCachedDataSetOption: (cdsoCopyIndices, cdsoSetVisibleFields)
- TnxCachedDataSetOptions: set of TnxCachedDataSetOption
- TnxDataset - inherits from TDataSet
- Method(s)
- Procedure PostAndEdit
- Function KeyAsVariant : Variant
- Procedure GotoCurrent( aDataSet : TnxDataset)
- Procedure RecordCountAsync( out aTaskInfo : TnxAbstractTaskInfo)
- Function Exists : Boolean
- Procedure GetAutoIncValue( out aValue : TnxWord32)
- Procedure SetAutoIncValue( aValue : TnxWord32)
- Procedure LockTable( aLockType : TnxLockType)
- Procedure UnlockTable( aLockType : TnxLockType)
- Procedure UnlockTableAll
- Function IsTableLocked( aLockType : TnxLockType) : TnxLockPresent
- Function IsRecordLocked : TnxLockPresent
- Procedure AddFileBlob( aField : TField; const aFileName : string)
- Function AddFileBlobEx( aField : TField; const aFileName : string) : TnxResult
- Procedure CopyRecords( aSrcTable : TnxDataset; aCopyBLOBs : Boolean; aMaxTransSize : Integer)
- Procedure CopyRecordsEx( aSrcTable : TnxDataset; aCopyBLOBs : Boolean; aMaxTransSize : Integer; aCheckValFields : Boolean)
- Procedure DeleteRecords
- Procedure BeginBatchAppend( aCutoffSize : Integer)
- Procedure FlushBatchAppend
- Procedure EndBatchAppend
- Procedure CancelBatchAppend
- Procedure BatchPost
- Function InBatchAppend : Boolean
- Procedure GetStreamList( aStreams : TStrings)
- Procedure WriteStream( const aName : string; aStream : TStream)
- Procedure ReadStream( const aName : string; aStream : TStream)
- Function ReadStreamEx( const aName : string; aStream : TStream) : TnxResult
- Procedure DeleteStream( const aName : string)
- Properties
- AbstractCursor: TnxAbstractCursor
- _Dictionary: TnxDataDictionary
- TableDescriptor: TnxBaseTableDescriptor
- FieldsDescriptor: TnxFieldsDescriptor
- SimpleExpressionFilterClass:
- TnxSimpleExpressionFilterDescriptorClass
- SqlFilterClass: TnxSqlFilterDescriptorClass
- ActiveRuntime: Boolean
- ActiveDesigntime: Boolean
- Session: TnxBaseSession
- AliasName: string
- Database: TnxDatabase
- Timeout: Integer
- Options: TnxDataSetOptions
- FilterResync: boolean
- FilterType: TnxFilterType
- FilterTimeout: TnxWord32
- OnServerFilterTimeout: TnxServerFilterTimeoutEvent
- BlockReadOptions: TnxRecordGetBatchExOptions
- FlipOrder: Boolean
- Version: string
- TnxIndexDataset - inherits from TnxDataSet
- Method(s)
- Procedure GetIndexNames( aList : TStrings)
- Function FindKey1( const aKeyValues : array of const) : Boolean;
- Function FindKey2( const aKeyValues : array of const; aOptions : TnxSetKeyOptions) : Boolean;
- Procedure FindNearest1( const aKeyValues : array of const);
- Procedure FindNearest2( const aKeyValues : array of const; aOptions : nxSetKeyOptions);
- Procedure SetKey
- Procedure EditKey
- Function GotoKey : Boolean
- Procedure GotoNearest
- Procedure GotoNearestBackward
- Procedure SetRangeSimple1( const aValue : array of const; aOptions : TnxSetKeyOptions);
- Procedure SetRangeShared1( const aSharedValue, aStartValues, aEndValues : array of const; aOptions : TnxSetKeyOptions);
- Procedure SetRangeShared1( const aSharedValue, aStartValues, aEndValues : array of const; aStartOptions, aEndOptions : TnxSetKeyOptions);
- Procedure SetRange1( const aStartValues, aEndValues : array of const);
- Procedure SetRange2( const aStartValues, aEndValues : array of const; aOptions : TnxSetKeyOptions);
- Procedure SetRange3( const aStartValues, aEndValues : array of const; aStartOptions, aEndOptions : TnxSetKeyOptions);
- Procedure SetRangeStart
- Procedure EditRangeStart
- Procedure SetRangeEnd
- Procedure EditRangeEnd
- Procedure ApplyRange
- Procedure CancelRange
- TnxMemTable - inherits from TnxIndexDataset
- Properties
- StoreDefs: Boolean
- TableName: String
- UsedTableName: String
- OnCreateTable: TnxCreateTableEvent
- Properties
- TnxCachedDataSet - inherits from TnxIndexDataset
- Properties
- ReadOnly: Boolean
- AddIndexDefs: TIndexDefs
- AddFieldDefs: TFieldDefs
- SourceDataSet: TnxDataset
- BatchSize: Integer
- Options: TnxCachedDataSetOptions
- TableName: String
- UsedTableName: String
- UpdateObject: TnxBaseUpdateObject
- OnCreateTable: TnxCreateTableEvent
- Properties
- TnxTable - inherits from TnxIndexDataset
- Method(s)
- Procedure CreateTable( aTableScope : TnxTableScope; aNoIndices : Boolean)
- Procedure CreateTableEx( aBlockSize : TnxBlockSize; aTableScope : TnxTableScope; aNoIndices : Boolean)
- Procedure DeleteTable
- Procedure EmptyTable
- Procedure RenameTable( const aNewTableName : string)
- Function PackTable : TnxAbstractTaskInfo
- Function PackTableEx( out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Function ReIndexTable1( aIndexNum : Integer) : TnxAbstractTaskInfo;
- Function ReIndexTableEx1( aIndexNum : Integer; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult;
- Function ReIndexTable1( const aIndexName : string) : TnxAbstractTaskInfo;
- Function ReIndexTableEx2( const aIndexName : string; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult;
- Function RestructureTable( aDictionary : TnxDataDictionary; aMapperDesc : TnxBaseTableMapperDescriptor) : TnxAbstractTaskInfo
- Function RestructureTableEx( aDictionary : TnxDataDictionary; aMapperDesc : TnxBaseTableMapperDescriptor; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Procedure AddIndex( const aName : string; const aFields : string; aOptions : TIndexOptions; const aCaseInsFields : string; const aDescFields : string; aNewPrimary : Boolean)
- Function AddIndexEx( aIndexDesc : TnxIndexDescriptor; aNewPrimary : Boolean; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Procedure DeleteIndex( const aIndexName : string)
- Procedure ChangePassword( const aNewPassword : string)
- Properties
- TableName: string
- Password: string
- ReadOnly: Boolean
- Exclusive: Boolean
- WriteOnly: Boolean
- StoreDefs: Boolean
- OnCreateTable: TnxCreateTableEvent
- Method(s)
- Method(s)
- TnxStatementDataSet - inherits from TnxDataset
- Method(s)
- Procedure Prepare
- Procedure Unprepare
- Function ParamByName(const aName: String): TParam
- Properties
- Log: TStringList
- Prepared: Boolean
- RowsAffected: Integer
- RecordsRead: Integer
- ParamCount: Word
- DataSource: TDataSource
- Params: TParams
- RequestLive: Boolean
- ReadOnly: Boolean
- TnxStoredProc - inherits from TnxStatementDataSet
- Method(s)
- Procedure RefreshParam
- Procedure ExecProc
- Properties
- StoredProcName: String
- Method(s)
- TnxQuery - inherits from TnxStatementDataSet
- Method(s)
- Procedure ExecSQL
- Properties
- Text: WideString
- ParamCheck: Boolean
- SQL: TStrings
- Method(s)
- Method(s)
- Method(s)
- TnxStatementDataSetDataLink - inherits from TDetailDataLink
- Method(s)
- Constructor Create (aStatementDataSet: TnxStatementDataset)
- Method(s)
- TnxCursor - inherits from TnxDataAccessStateComponent
- Method(s)
- Constructor Create(aDataSet: TnxDataSet)
- Properties
- Database: TnxDatabase
- TnxCachedDataSetCursor
- Properties
- UpdateHandler: TnxBaseUpdateHandler
- Properties
- Method(s)
- TnxDataAccessStateComponent
- TnxBaseSession - inherits from TnxDataAccessStateComponent
- Method(s)
- Function IsConnected : Boolean
- Procedure CancelProcessing
- Procedure AddAlias( const aName : string; const aPath : string; aEnforce: Boolean)
- Function AddAliasEx( const aName : string; const aPath : string; aEnforce: Boolean) : TnxResult
- Procedure DeleteAlias( const aName : string)
- Function DeleteAliasEx( const aName : string) : TnxResult
- Procedure ModifyAlias( const aName : string; const aNewName : string; const aNewPath : string; aEnforce: Boolean)
- Function ModifyAliasEx( const aName : string; const aNewName : string; const aNewPath : string; aEnforce: Boolean) : TnxResult
- Procedure GetAliasNames( aList : TStrings)
- Function GetAliasNamesEx( aList : TStrings; aEmptyList : Boolean) : TnxResult
- Procedure GetAliasPath( const aName : string; out aPath : string)
- Function GetAliasPathEx( const aName : string; out aPath : string) : TnxResult
- Function IsAlias( const aName : string) : Boolean
- Procedure PasswordAdd( const aPassword : string)
- Procedure PasswordRemove( const aPassword : string)
- Procedure PasswordRemoveAll
- Procedure CloseInactiveFolders
- Procedure CloseInactiveTables
- Procedure GetTableNames( const aAliasName : string; aList : TStrings)
- Procedure GetChangedTables( const aAliasName : string; aList : TStrings)
- Function TableExists( const aAliasName : string; const aTableName : string; const aPassword : string) : Boolean
- Procedure GetStoredProcNames( const aAliasName : string; aList : TStrings)
- Procedure GetStoredProcParams( const aAliasName : string; const aStoredProcName : string; out aParams : TnxSqlParamList)
- Procedure GetStoredFuncNames( const aAliasName : string; aList : TStrings)
- Procedure GetStoredFuncParams( const aAliasName : string; const aStoredFuncName : string; out aParams : TnxSqlParamList)
- Procedure GetRegisteredClassList( const aClassListType : TnxClassListType; aList : TStrings)
- Function OpenDatabase( const aAliasName : string) : TnxDatabase
- Function FindDatabase( const aAliasName : string) : TnxDatabase
- Function DefaultSession : TnxBaseSession
- Function DefaultDatabase : TnxDatabase
- Function DefaultTransContext : TnxTransContext
- Properties
- ServerEngine: TnxBaseServerEngine
- AbstractSession: TnxAbstractSession
- ServerVersion: Integer
- DatabaseCount: Integer
- Databases: TnxDatabase Integer
- TransContextCount: Integer
- TransContexts: TnxTransContext Integer
- OnLogin: TnxLoginEvent
- CurrentUserName: string
- UserName: string
- Password: string
- PasswordRetries: Integer
- BeepOnLoginError: Boolean
- Timeout: Integer
- Default: Boolean
- SessionNotifications: InxSessionNotifications
- ClientLocaleAsDefault: Boolean
- TnxSession - inherits from TnxBaseSession
- Properties
- ServerEngine: TnxBaseServerEngine
- Properties
- TnxPooledSession - inherits from TnxBaseSession
- Method(s)
- Procedure AddRef
- Procedure Release
- Properties
- SessionPool: TnxBaseSessionPool
- Method(s)
- Method(s)
- TnxBaseSessionPool - inherits from TnxDataAccessStateComponent
- TnxSessionPool - inherits from TnxBaseSessionPool
- Method(s)
- Function AcquireSession: TnxPooledSession
- Properties
- ServerEngine: TnxBaseServerEngine
- UserName: String
- Password: String
- Timeout: Integer
- Method(s)
- TnxSessionPool - inherits from TnxBaseSessionPool
- TnxSessionOwnedDataAccessStateComponent - inherits from TnxDataAccessStateComponent
- Properties
- Session: TnxBaseSession
- Timeout: Integer
- TnxTransContext - inherits from TnxSessionOwnedDataAccessStateComponent
- Method(s)
- Procedure StartTransaction( aSnapShot : Boolean)
- Function TryStartTransaction( aSnapShot : Boolean) : Boolean
- Procedure StartTransactionWith( const aTables : array of TnxTable; aSnapShot : Boolean)
- Function StartTransactionWithEx( const aTables : array of TnxTable; aSnapShot : Boolean) : TnxResult
- Procedure Commit
- Procedure Rollback
- Procedure TransactionCorrupted
- Properties
- InTransaction: Boolean
- DatabaseCount: Integer
- Databases: TnxDatabase Integer
- FailSafe: Boolean
- Default: Boolean
- Method(s)
- TnxDatabase - inherits from TnxSessionOwnedDataAccessStateComponent
- Method(s)
- Function ExecQuery( const aQuery : string; const aParams : array of const) : TnxDynVariantArray
- Function ExecQueryFromFile( const aFileName : string; const aParams : array of const) : TnxDynVariantArray
- Function ExecQueryFromStream( aStream : TStream; const aParams : array of const) : TnxDynVariantArray
- Function ExecStoredProc( const aStoredProcName : string; const aParams : array of const) : TnxDynVariantArray
- Function OpenQuery( const aQuery : string; const aParams : array of const; aBlockReadSize : Integer; aRequestLive : Boolean) : TnxQuery
- Function OpenStoredProc( const aStoredProcName : string; const aParams : array of const; aBlockReadSize : Integer) : TnxStoredProc
- Function OpenTable( const aTableName : string; const aIndexName : string; aBlockReadSize : Integer) : TnxTable
- Procedure GetStoredProcNames( aList : TStrings)
- Procedure GetStoredProcParams( const aStoredProcName : string; out aParams : TnxSqlParamList)
- Procedure GetStoredFuncNames( aList : TStrings)
- Procedure GetStoredFuncParams( const aStoredFuncName : string; out aParams : TnxSqlParamList)
- Procedure GetTableNames( aList : TStrings)
- Procedure GetChangedTables( aList : TStrings)
- Function TableExists( const aTableName : string; const aPassword : string) : Boolean
- Procedure CreateTable( aOverWrite : Boolean; const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary; aTableScope : TnxTableScope)
- Function CreateTableEx( aOverWrite : Boolean; const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary; aTableScope : TnxTableScope) : TnxResult
- Procedure DeleteTable( const aTableName : string; const aPassword : string)
- Procedure EmptyTable( const aTableName : string; const aPassword : string)
- Procedure RenameTable( const aOldName, aNewName, aPassword : string)
- Function PackTable( const aTableName : string; const aPassword : string) : TnxAbstractTaskInfo
- Function PackTableEx( const aTableName : string; const aPassword : string; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Function BackupTable( const aTableName : string; const aPassword : string; aTarget : TnxDatabase) : TnxAbstractTaskInfo
- Function BackupTableEx( const aTableName : string; const aPassword : string; aTarget : TnxDatabase; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Function ReIndexTable1( const aTableName : string; const aPassword : string; aIndexNum : Integer) : TnxAbstractTaskInfo;
- Function ReIndexTable2( const aTableName : string; const aPassword : string; const aIndexName : string) : TnxAbstractTaskInfo;
- Function ReIndexTableEx1( const aTableName : string; const aPassword : string; aIndexNum : Integer; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult;
- Function ReIndexTableEx2( const aTableName : string; const aPassword : string; const aIndexName : string; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult;
- Function RestructureTable( const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary; aMapperDesc : TnxBaseTableMapperDescriptor) : TnxAbstractTaskInfo
- Function RestructureTableEx( const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary; aMapperDesc : TnxBaseTableMapperDescriptor; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Procedure ChangePassword( const aTableName : string; const aOldPassword : string; const aNewPassword : string)
- Function ChangePasswordEx( const aTableName : string; const aOldPassword : string; const aNewPassword : string) : TnxResult
- Function RecoverTable( const aTableName : string; const aPassword : string) : TnxAbstractTaskInfo
- Function RecoverTableEx( const aTableName : string; const aPassword : string; out aTaskInfo : TnxAbstractTaskInfo) : TnxResult
- Procedure GetDataDictionary( const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary)
- Function GetDataDictionaryEx( const aTableName : string; const aPassword : string; aDictionary : TnxDataDictionary) : TnxResult
- Procedure GetAutoIncValue( const aTableName : string; const aPassword : string; out aValue : TnxWord32)
- Procedure StartTransaction( aSnapShot : Boolean)
- Function TryStartTransaction( aSnapShot : Boolean) : Boolean
- Procedure StartTransactionWith( const aTables : array of TnxTable; aSnapShot : Boolean)
- Function StartTransactionWithEx( const aTables : array of TnxTable; aSnapShot : Boolean) : TnxResult
- Procedure Commit
- Procedure Rollback
- Procedure TransactionCorrupted
- Function GetFreeDiskSpace : TnxInt64
- Function GetFreeDiskSpaceEx( out aFreeSpace : TnxInt64) : TnxResult
- Function GetPath : string
- Function Exists : Boolean
- Properties
- AbstractDatabase: TnxAbstractDatabase
- InTransaction: Boolean
- Implicit: Boolean
- Path: string
- DataSetCount: Integer
- DataSets: TnxDataset Integer
- TableCount: Integer
- Tables: TnxTable Integer
- QueryCount: Integer
- Queries: TnxStatementDataSet Integer
- TransContext: TnxTransContext
- AliasName: string
- AliasPath: string
- ReadOnly: Boolean
- Exclusive: Boolean
- FailSafe: Boolean
- Default: Boolean
- Method(s)
- Properties
- TnxBaseUpdateHandler - inherits from TnxDataAccessStateComponent
- TnxSqlUpdateHandler - inherits from TnxBaseUpdateHandler
- TnxBaseSession - inherits from TnxDataAccessStateComponent
- TnxBaseUpdateObject - inherits from TnxComponent
- TnxSqlUpdateObject
- Properties
- Sql: TStrings TUpdateKind
- ModifySql: TStrings
- InsertSql: TStrings
- DeleteSql: TStrings
- Params: TParams
- Properties
- TnxSqlUpdateObject
- TnxCachedDataSetCursorExtender - inherits from TnxBaseEngineExtender
- Method(s)
- Constructor Create(aCursor: TnxAbstractCursor; aUpdateHandler: TnxBaseUpdateHandler)
- Method(s)
- TnxCachedDataSetDatabaseExtender - inherits from TnxBaseEngineExtender
- Method(s)
- Constructor Create(aDatabase: TnxAbstractDatabase)
- Procedure AddDataSet(aDataSet: TnxCachedDataSet)
- Procedure RemoveDataSet(aDataSet: TnxCachedDataSet)
- Method(s)
- TnxKeyAsVariantField - inherits from TVariantField
- TnxMemoField - inherits from TMemoField
- Properties
- AsWideString: WideString
- Properties
- TnxBaseBlobStream - inherits from TStream
- Method(s)
- Procedure Truncate
- TnxBlobStream - inherits from TnxBaseBlobStream
- Properties
- ChunkSize: Integer
- Properties
- TnxMemoBlobStream - inherits from TnxBaseBlobStream
- TnxBatchAppendBlobStream - inherits from TnxBaseBlobStream
- TnxBlockModeBlobStream - inherits from TnxBaseBlobStream
- Method(s)
- TnxThreadWithSession
- Method(s)
- Constructor Create( aThreadPriority : TThreadPriority; aSessionPool : TnxBaseSessionPool)
- Properties
- Session: TnxBaseSession
- TnxThreadWithDatabase - inherits from TnxThreadWithSession
- Method(s)
- Constructor Create( aThreadPriority : TThreadPriority; aSessionPool : TnxBaseSessionPool; const aAlias : string)
- Properties
- Database: TnxDatabase
- TnxThreadWithTable - inherits from TnxThreadWithDatabase
- Method(s)
- Constructor Create( aThreadPriority : TThreadPriority; aSessionPool : TnxBaseSessionPool; const aAlias : string; const aTableName : string; const aIndexName : string; const aPassword : string)
- Properties
- Table: TnxTable
- Method(s)
- Method(s)
- Method(s)
- Constant(s)
- nxdbBackupController
- TnxBackupController
- Constant(s)
- rsCopyingDictionaries: String = 'Copying data dictionary ...'
- rsCopyingRecords: String = 'Copying records...'
- rsRebuildingIndexes: String = 'Rebuilding Table Indexes...'
- rsCopyingDictionaries: String = 'Copying data dictionary ...'
- Method(s)
- Procedure Backup
- Procedure Restore
- Properties
- Mode: TnxbcMode
- ProcessedNoError: Integer
- CurrentAction: String
- OriginalDatabase: TnxDatabase
- CloneDatabase: TnxDatabase
- BatchSize: TnxWord32
- MaxTransSizeMB: TnxWord32
- OnIncludeTable: TnxOnTableNameEvent
- OnOverwriteTable: TnxOnTableNameEvent
- OnAfterTableOpen: TnxAfterTableOpenEvent
- OnTableProgress: TnxOnTableProgressEvent
- OnReportError: TnxOnReportErrorEvent
- KeepIndexes: Boolean
- OnGetPasswordEvent: TnxOnGetPasswordEvent
- EncryptionEngine: string
- BackupPassword: UnicodeString
- Options: TnxbcOptions
- SourceThreadPriority: TnxThreadPriority
- TargetThreadPriority: TnxThreadPriority
- SkippedTablesCount: Integer
- Mode: TnxbcMode
- Type(s)
- TnxbcOption: ( bcoCloseInactiveOnSource, bcoCloseInactiveOnTarget )
- TnxbcOptions: set of TnxbcOption
- TnxbcMode: ( bcmNone, bcmBackup, bcmRestore )
- TnxErrorAction: ( eaFail, eaAbort, eaTryNext )
- TnxOnTableNameEvent: Procedure ( aSender : TnxBackupController; const aTableName : string; var aUseTable : Boolean)
- TnxAfterTableOpenEvent: Procedure ( aSender : TnxBackupController; aTable : TnxTable; aIsSource : Boolean)
- TnxOnReportErrorEvent: Procedure ( aSender : TnxBackupController; const aTableName : string; aException : TObject; var aAction : TnxErrorAction)
- TnxOnTableProgressEvent: Procedure ( aSender : TnxBackupController; aPercentDone : Integer)
- TnxOnGetPasswordEvent: Procedure ( aSender : TnxBackupController; var aTablePassword : UnicodeString)
- TnxbcOption: ( bcoCloseInactiveOnSource, bcoCloseInactiveOnTarget )
- nxllComponent
- nxllSimpleOutputCache
- nxllTypes
- nxsdDataDictionary
- nxsdServerEngine
- nxServerLink
- nxsrServerEngine
- nxWebServer
- nxsdTypes
- nxSqlFunctionsScript
- nxsqlPSM
- nxsrSystemStorage
- TnxSystemDatabase
- TnxsdCursorWrapper
- TnxDataDictionary
- TnxComponent
nxServer PascalScript "nxsdTypes"
- Type(s)
- TnxCursorID: TnxBaseID
- TnxDatabaseID: TnxBaseID
- TnxTransContextID: TnxBaseID
- TnxTaskID: TnxBaseID
- TnxFilterID: TnxBaseID
- TnxKeyFilterID: TnxBaseID
- TnxStatementID: TnxBaseID
- TnxTransID: TnxBaseID
- TnxGrowSize: Integer
- TnxRecordGetBatchExOption: (gboBlobs, gboBookmarks, gboBackwards)
- TnxRecordGetBatchExOptions: set of TnxRecordGetBatchExOption
- TnxFieldType: (nxtBoolean, nxtChar, nxtWideChar, nxtByte, nxtWord16, nxtWord32, nxtInt8, nxtInt16, nxtInt32, nxtInt64, nxtAutoInc, nxtSingle, nxtDouble, nxtExtended, nxtCurrency, nxtDate, nxtTime, nxtDateTime, nxtInterval, nxtBlob, nxtBlobMemo, nxtBlobGraphic, nxtByteArray, nxtShortString, nxtNullString, nxtWideString, nxtRecRev, nxtGuid, nxtBCD, nxtBlobWideMemo, nxtFmtBCD)
- TnxFieldTypes: set of TnxFieldType
- TnxOpenMode: (omReadOnly, omWriteOnly, omReadWrite)
- TnxShareMode: (smExclusive, smShared, smShareRead)
- TnxLockType: (nxltNoLock, nxltReadLock, nxltWriteLock)
- TnxLockPresent: (lpNotAtAll, lpYesByUs, lpYesByAnother)
- TnxSearchKeyAction: (skaEqualFirst, skaGreaterEqual, skaGreater, skaEqualLast, skaSmallerEqual, skaSmaller, skaAnyEqual, skaAnyGreaterEqual, skaAnyGreater, skaAnySmallerEqual, skaAnySmaller)
- TnxBlobCopyMode: (nxbcmNoCopy, nxbcmCopyFull, nxbcmCreateLink)
- TnxParamType: (nxptUnknown, nxptInput, nxptOutput, nxptInputOutput, nxptResult)
- TnxSqlParamDesc:
record
piParamName : string;
piParamType : TnxParamType;
piDataType : TnxFieldType;
piData : TnxDynByteArray;
end - TnxSqlParamList: array of TnxSqlParamDesc
- TnxStatementType: (stQuery, stStoredProcedure)
- TnxRecordCountOption: (rcoTotalRecordCount, rcoTotalKeyCount, rcoRangedKeyCount, rcoServerFilteredKeyCount, rcoClientFilteredKeyCount)
- TnxIndexPathPosition: (ippUnknown, ippBof, ippOnCrackBefore, ippOnCrackAfter, ippOnKey, ippEof)
- TnxClassListType: (setAutoIncEngines, setBlobEngines, setIndicesEngines, setEncryptionEngines, setDefaultDescriptors, setValidationDescriptors, setRecordDescriptors, setRIActionDescriptors)
- TnxLockResult: (lrGrantedNew, lrGrantedExisting, lrConflictUnknown, lrConflictCursorWriteLock, lrConflictCursorReadLockSingle, lrConflictCursorReadLockMultiple, lrConflictCursorRecordLockSingle, lrConflictCursorRecordLockMultiple, lrConflictTransaction)
- TnxLockRequestType: (lrtRecordLock, lrtReadLock, lrtWriteLock)
- TnxLockConflictType: (lctUnknown, lctRecordLock, lctReadLock, lctWriteLock, lctTransaction
- Constant(s)
- nxcStringTypes: LongInt = ord(nxtShortString) or ord(nxtNullString) or ord(nxtWideString) or ord(nxtBlobMemo) or ord(nxtBlobWideMemo)
- nxcVariableLengthTypes: LongInt = ord(nxtByteArray) or ord(nxtShortString) or ord(nxtNullString) or ord(nxtWideString) or ord(nxtFmtBCD)
nxServer PascalScript "classes"
- TStrings
- TStringList
- TBits
- TStream
- THandleStream
- TMemoryStream
- TFileStream
- TCustomMemoryStream
- TResourceStream
- TParser
- TCollection
- TOwnedCollection
- Type(s)
- TAlignment: (taLeftJustify, taRightJustify, taCenter)
- THelpEvent: function (Command: Word; Data: LongInt; var CallHelp: Boolean): Boolean
- TGetStrProc: procedure(const S: string)
- TDuplicates: (dupIgnore, dupAccept, dupError)
- TOperation: (opInsert, opRemove)
- THANDLE: LongInt
- TNotifyEvent: procedure (Sender: TObject)
- TAlignment: (taLeftJustify, taRightJustify, taCenter)
- Constant(s)
- soFromBeginning: LongInt = 0
- soFromCurrent: LongInt = 1
- soFromEnd: LongInt = 2
- toEOF: Char = #0
- toSymbol: Char = #1
- toString: Char = #2
- toInteger: Char = #3
- toFloat: Char = #4
- fmCreate: LongInt = $FFFF
- fmOpenRead: LongInt = 0
- fmOpenWrite: LongInt = 1
- fmOpenReadWrite: LongInt = 2
- fmShareCompat: LongInt = 0
- fmShareExclusive: LongInt = $10
- fmShareDenyWrite: LongInt = $20
- fmShareDenyRead: LongInt = $30
- fmShareDenyNone: LongInt = $40
- SecsPerDay: LongInt = 86400
- MSecPerDay: LongInt = 86400000
- DateDelta: LongInt = 693594
- soFromBeginning: LongInt = 0
nxServer PascalScript "ComObj"
- Type(s)
- HResult: LongInt
- TGUID
record
D1: LongWord;
D2: Word;
D3: Word;
D4: array[0..7] of Byte;
end - TCLSID: TGUID
- TIID: TGUID
- HResult: LongInt
- Method(s)
- procedure OleCheck(Result: HResult);
- function StringToGUID(const S: String): TGUID
- function CreateComObject(const ClassID: TGUID): IUnknown;
- function CreateOleObject(const ClassName: String): IDispatch;
- function GetActiveOleObject(const ClassName: String): IDispatch;
- procedure OleCheck(Result: HResult);
nxServer PascalScript "SysUtils"
- Type(s)
- TBytes: array of Byte
- TSysCharSet: set of Char
- TFileName: string
- TFloatValue: (fvExtended, fvCurrency)
- TFloatFormat: (ffGeneral, ffExponent, ffFixed, ffNumber, ffCurrency)
- TTimeStamp:
record
Time : Integer;
Date : Integer;
end - TMbcsByteType: (mbSingleByte, mbLeadByte, mbTrailByte)
- TSysLocale:
record
DefaultLCID : Integer;
PriLangID : Integer;
SubLangID : Integer;
FarEast : Boolean;
MiddleEast : Boolean;
end - TLocaleOptions: (loInvariantLocale, loUserLocale)
- TFilenameCaseMatch: (mkNone, mkExactMatch, mkSingleMatch, mkAmbiguous)
- TReplaceFlag: (rfReplaceAll, rfIgnoreCase)
- TReplaceFlags: set of TReplaceFlag
Constant(s)
|
|
Method(s)
- Function CheckWin32Version( AMajor : Integer; AMinor : Integer) : Boolean
- Function GetFileVersion( const AFileName : string) : Cardinal
- Procedure AppendStr( var Dest : string; const S : string)
- Function UpperCase( const S : string) : string;
- Function LowerCase( const S : string) : string;
- Function CompareStr( const S1, S2 : string) : Integer;
- Function SameStr( const S1, S2 : string) : Boolean;
- Function CompareText( const S1, S2 : string) : Integer;
- Function SameText( const S1, S2 : string) : Boolean;
- Function AnsiUpperCase( const S : string) : string
- Function AnsiLowerCase( const S : string) : string
- Function AnsiCompareStr( const S1, S2 : string) : Integer
- Function AnsiSameStr( const S1, S2 : string) : Boolean
- Function AnsiCompareText( const S1, S2 : string) : Integer
- Function AnsiSameText( const S1, S2 : string) : Boolean
- Function WideUpperCase( const S : WideString) : WideString
- Function WideLowerCase( const S : WideString) : WideString
- Function WideCompareStr( const S1, S2 : WideString) : Integer
- Function WideSameStr( const S1, S2 : WideString) : Boolean
- Function WideCompareText( const S1, S2 : WideString) : Integer
- Function WideSameText( const S1, S2 : WideString) : Boolean
- Function Trim( const S : string) : string;
- Function TrimLeft( const S : string) : string;
- Function TrimRight( const S : string) : string;
- Function QuotedStr( const S : string) : string
- Function AnsiQuotedStr( const S : string; Quote : Char) : string
- Function AnsiDequotedStr( const S : string; AQuote : Char) : string
- Function IsValidIdent( const Ident : string; AllowDots : Boolean) : Boolean
- Function IntToStr( Value : Integer) : string;
- Function IntToHex( Value : Integer; Digits : Integer) : string;
- Function StrToInt( const S : string) : Integer
- Function StrToIntDef( const S : string; Default : Integer) : Integer
- Function TryStrToInt( const S : string; out Value : Integer) : Boolean
- Function StrToInt64( const S : string) : Int64
- Function StrToInt64Def( const S : string; const Default : Int64) : Int64
- Function TryStrToInt64( const S : string; out Value : Int64) : Boolean
- Function StrToBool( const S : string) : Boolean
- Function StrToBoolDef( const S : string; const Default : Boolean) : Boolean
- Function TryStrToBool( const S : string; out Value : Boolean) : Boolean
- Function BoolToStr( B : Boolean; UseBoolStrs : Boolean) : string
- Function LoadStr( Ident : Integer) : string
- Function FmtLoadStr( Ident : Integer; const Args : array of const) : string
- Function FileOpen( const FileName : string; Mode : LongWord) : Integer
- Function FileCreate( const FileName : string) : Integer;
- Function FileRead( Handle : Integer; var Buffer, Count : LongWord) : Integer
- Function FileWrite( Handle : Integer; const Buffer, Count : LongWord) : Integer
- Function FileSeek( Handle, Offset, Origin : Integer) : Integer;
- Procedure FileClose( Handle : Integer)
- Function FileAge( const FileName : string) : Integer;
- Function FileExists( const FileName : string) : Boolean
- Function DirectoryExists( const Directory : string) : Boolean
- Function ForceDirectories( Dir : string) : Boolean
- Function FileGetDate( Handle : Integer) : Integer
- Function FileSetDate( const FileName : string; Age : Integer) : Integer;
- Function FileGetAttr( const FileName : string) : Integer
- Function FileSetAttr( const FileName : string; Attr : Integer) : Integer
- Function FileIsReadOnly( const FileName : string) : Boolean
- Function FileSetReadOnly( const FileName : string; ReadOnly : Boolean) : Boolean
- Function DeleteFile( const FileName : string) : Boolean
- Function RenameFile( const OldName, NewName : string) : Boolean
- Function IsAssembly( const FileName : string) : Boolean
- Function ChangeFileExt( const FileName, Extension : string) : string
- Function ChangeFilePath( const FileName, Path : string) : string
- Function ExtractFilePath( const FileName : string) : string
- Function ExtractFileDir( const FileName : string) : string
- Function ExtractFileDrive( const FileName : string) : string
- Function ExtractFileName( const FileName : string) : string
- Function ExtractFileExt( const FileName : string) : string
- Function ExpandFileName( const FileName : string) : string
- Function ExpandFileNameCase( const FileName : string; out MatchFound : TFilenameCaseMatch) : string
- Function ExpandUNCFileName( const FileName : string) : string
- Function ExtractRelativePath( const BaseName, DestName : string) : string
- Function ExtractShortPathName( const FileName : string) : string
- Function FileSearch( const Name, DirList : string) : string
- Function DiskFree( Drive : Byte) : Int64
- Function DiskSize( Drive : Byte) : Int64
- Function GetCurrentDir : string
- Function SetCurrentDir( const Dir : string) : Boolean
- Function CreateDir( const Dir : string) : Boolean
- Function RemoveDir( const Dir : string) : Boolean
- Function Format( const Format : string; const Args : array of const) : string;
- Procedure FmtStr( var Result : string; const Format : string; const Args : array of const);
- Function FormatBuf( var Buffer, BufLen : Cardinal; const Format, FmtLen : Cardinal; const Args : array of const) : Cardinal;
- Function WideFormat( const Format : WideString; const Args : array of const) : WideString;
- Procedure WideFmtStr( var Result : WideString; const Format : WideString; const Args : array of const);
- Function WideFormatBuf( var Buffer, BufLen : Cardinal; const Format, FmtLen : Cardinal; const Args : array of const) : Cardinal;
- Function FloatToStr( Value : Extended) : string;
- Function CurrToStr( Value : Currency) : string;
- Function FloatToCurr( const Value : Extended) : Currency
- Function TryFloatToCurr( const Value : Extended; out AResult : Currency) : Boolean
- Function FloatToStrF( Value : Extended; Format : TFloatFormat; Precision, Digits : Integer) : string;
- Function CurrToStrF( Value : Currency; Format : TFloatFormat; Digits : Integer) : string;
- Function FormatFloat( const Format : string; Value : Extended) : string;
- Function FormatCurr( const Format : string; Value : Currency) : string;
- Function StrToFloat( const S : string) : Extended;
- Function StrToFloatDef( const S : string; const Default : Extended) : Extended;
- Function TryStrToFloat( const S : string; out Value : Extended) : Boolean;
- Function StrToCurr( const S : string) : Currency;
- Function StrToCurrDef( const S : string; const Default : Currency) : Currency;
- Function TryStrToCurr( const S : string; out Value : Currency) : Boolean;
- Function DateTimeToTimeStamp( aDateTime : TDateTime) : TTimeStamp
- Function TimeStampToDateTime( const aTimeStamp : TTimeStamp) : TDateTime
- Function EncodeDate( Year, Month, Day : Word) : TDateTime
- Function EncodeTime( Hour, Min, Sec, MSec : Word) : TDateTime
- Function TryEncodeDate( Year, Month, Day : Word; out Date : TDateTime) : Boolean
- Function TryEncodeTime( Hour, Min, Sec, MSec : Word; out Time : TDateTime) : Boolean
- Procedure DecodeDate( const DateTime : TDateTime; var Year, Month, Day : Word)
- Function DecodeDateFully( const DateTime : TDateTime; var Year, Month, Day, DOW : Word) : Boolean
- Procedure DecodeTime( const DateTime : TDateTime; var Hour, Min, Sec, MSec : Word)
- Function DayOfWeek( const DateTime : TDateTime) : Word
- Function Date : TDateTime
- Function Time : TDateTime
- Function GetTime : TDateTime
- Function Now : TDateTime
- Function CurrentYear : Word
- Function IncMonth( const DateTime : TDateTime; NumberOfMonths : Integer) : TDateTime
- Procedure IncAMonth( var Year, Month, Day : Word; NumberOfMonths : Integer)
- Procedure ReplaceTime( var DateTime : TDateTime; const NewTime : TDateTime)
- Procedure ReplaceDate( var DateTime : TDateTime; const NewDate : TDateTime)
- Function DateToStr( const DateTime : TDateTime) : string;
- Function TimeToStr( const DateTime : TDateTime) : string;
- Function DateTimeToStr( const DateTime : TDateTime) : string;
- Function StrToDate( const S : string) : TDateTime;
- Function StrToDateDef( const S : string; const Default : TDateTime) : TDateTime;
- Function TryStrToDate( const S : string; out Value : TDateTime) : Boolean;
- Function StrToTime( const S : string) : TDateTime;
- Function StrToTimeDef( const S : string; const Default : TDateTime) : TDateTime;
- Function TryStrToTime( const S : string; out Value : TDateTime) : Boolean;
- Function StrToDateTime( const S : string) : TDateTime;
- Function StrToDateTimeDef( const S : string; const Default : TDateTime) : TDateTime;
- Function TryStrToDateTime( const S : string; out Value : TDateTime) : Boolean;
- Function FormatDateTime( const Format : string; DateTime : TDateTime) : string;
- Procedure DateTimeToString( var Result : string; const Format : string; DateTime : TDateTime);
- Function FloatToDateTime( const Value : Extended) : TDateTime
- Function TryFloatToDateTime( const Value : Extended; out AResult : TDateTime) : Boolean
- Function SysErrorMessage( ErrorCode : Integer) : string
- Function GetLocaleStr( Locale, LocaleType : Integer; const Default : string) : string
- Function GetLocaleChar( Locale, LocaleType : Integer; Default : Char) : Char
- Procedure GetFormatSettings
- Procedure Sleep( milliseconds : Cardinal)
- Procedure Abort
- Procedure OutOfMemoryError
- Procedure Beep
- Function ByteToCharLen( const S : string; MaxLen : Integer) : Integer
- Function CharToByteLen( const S : string; MaxLen : Integer) : Integer
- Function ByteToCharIndex( const S : string; Index : Integer) : Integer
- Function CharToByteIndex( const S : string; Index : Integer) : Integer
- Function CharLength( const S : String; Index : Integer) : Integer
- Function NextCharIndex( const S : String; Index : Integer) : Integer
- Function IsPathDelimiter( const S : string; Index : Integer) : Boolean
- Function IsDelimiter( const Delimiters, S : string; Index : Integer) : Boolean
- Function IncludeTrailingPathDelimiter( const S : string) : string
- Function IncludeTrailingBackslash( const S : string) : string
- Function ExcludeTrailingPathDelimiter( const S : string) : string
- Function ExcludeTrailingBackslash( const S : string) : string
- Function LastDelimiter( const Delimiters, S : string) : Integer
- Function AnsiCompareFileName( const S1, S2 : string) : Integer
- Function SameFileName( const S1, S2 : string) : Boolean
- Function AnsiLowerCaseFileName( const S : string) : string
- Function AnsiUpperCaseFileName( const S : string) : string
- Function AnsiPos( const Substr, S : string) : Integer
- Function StringReplace( const S, OldPattern, NewPattern : string; Flags : TReplaceFlags) : string
- Function WrapText( const Line, BreakStr : string; const BreakChars : TSysCharSet; MaxCol : Integer) : string;
- Function FindCmdLineSwitch( const Switch : string; const Chars : TSysCharSet; IgnoreCase : Boolean) : Boolean;
- Procedure RaiseLastOSError;
- Procedure RaiseLastOSError( LastError : Integer);
- Procedure RaiseLastWin32Error
nxServer PascalScript "DateUtils"
- Type(s)
- TDateTime
- Method(s)
- function EncodeDate(Year, Month, Day: Word): TDateTime;
- function EncodeTime(Hour, Min, Sec, MSec: Word): TDateTime;
- function TryEncodeDate(Year, Month, Day: Word; var Date: TDateTime): Boolean;
- function TryEncodeTime(Hour, Min, Sec, MSec: Word; var Time: TDateTime): Boolean;
- procedure DecodeDate(const DateTime: TDateTime; var Year, Month, Day: Word);
- procedure DecodeTime(const DateTime: TDateTime; var Hour, Min, Sec, MSec: Word);
- function DayOfWeek(const DateTime: TDateTime): Word;
- function Date: TDateTime;
- function Time: TDateTime;
- function Now: TDateTime;
- function DateTimeToUnix(D: TDateTime): Int64;
- function UnixToDateTime(U: Int64): TDateTime;
- function DateToStr(D: TDateTime): String;
- function StrToDate(const s: String): TDateTime;
- function FormatDateTime(const fmt: String; D: TDateTime): String;