X# Runtime and VO SDK Reference

X# Runtime and VO SDK Reference

X# Runtime and SDK Reference

XSharp.RT Namespace

Functions, Globals and Defines

List of Functions

_accept Function (RT)

_ArrayToObjectArray Function (RT)

_ArrayToUsualArray Function (RT)

_Break Function (RT)

_CallClipFunc Function (RT)

_CreateInstance Function (RT)

_GetMRandID Function (RT)

_HasClipFunc Function (RT)

_MClear Function (RT)

_MRelease Function (RT)

_MRestore Function (RT)

_MSave Function (RT)

_MxRelease Function (RT)

_NoAlias Function (RT)

_ObjectArrayToUsualArray Function (RT)

_PrivateCount Function (RT)

_PrivateEnum Function (RT)

_PrivateFirst Function (RT)

_PrivateNext Function (RT)

_PublicCount Function (RT)

_PublicEnum Function (RT)

_PublicFirst Function (RT)

_PublicNext Function (RT)

_RegisterExit Function (RT)

_Select Function (RT)

_SelectString Function (RT)

_SequenceError Function (RT)

_SequenceRecover Function (RT)

_Str Function (RT)

_Str3 Function (RT)

_TextRestore Function (RT)

_TextSave Function (RT)

_UsualArrayToObjectArray Function (RT)

_VoDbErrInfoPtr Function (RT)

_wait Function (RT)

AAdd Function (RT)

Abs Function (RT)

AbsFloat Function (RT)

AClone Function (RT)

ACloneShallow Function (RT)

ACopy Function (RT)

ACos Function (RT)

ACot Function (RT)

ADel Function (RT)

ADim Function (RT)

ADimPic Function (RT)

ADir Function (RT)

AEval Function (RT)

AEvalA Function (RT)

AEvalOld Function (RT)

AFields Function (RT)

AFill Function (RT)

AIns Function (RT)

ALen Function (RT)

Alias Function (RT)

Alias0 Function (RT)

Alias0Sym Function (RT)

AllowCollectThread Function (RT)

Ansi2OemBuff Function (RT)

AReplicate Function (RT)

Array Function (RT)

ArrayBuild Function (RT)

ArrayCreate Function (RT)

ArrayDeProtect Function (RT)

ArrayGet Function (RT)

ArrayInit Function (RT)

ArrayNew Function (RT)

ArrayProtect Function (RT)

ArrayPut Function (RT)

ArrayStore Function (RT)

ArraySwap Function (RT)

AScan Function (RT)

AScanBin Function (RT)

AScanBinExact Function (RT)

AScanExact Function (RT)

ASend Function (RT)

AsHexString Function (RT)

ASin Function (RT)

ASize Function (RT)

ASort Function (RT)

AsPadr Function (RT)

AsString Function (RT)

AsSymbol Function (RT)

ATail Function (RT)

ATan Function (RT)

Atan2 Function (RT)

ATrueDel Function (RT)

Between Function (RT)

Bin2Date Function (RT)

Bin2F Function (RT)

Bin2Logic Function (RT)

BLOBDirectExport Function (RT)

BLOBDirectGet Function (RT)

BLOBDirectImport Function (RT)

BLOBDirectPut Function (RT)

BLOBExport Function (RT)

BLOBGet Function (RT)

BLOBImport Function (RT)

BLOBRootGet Function (RT)

BLOBRootLock Function (RT)

BLOBRootPut Function (RT)

BLOBRootUnlock Function (RT)

Bof Function (RT)

CanBreak Function (RT)

CDoW Function (RT)

Ceil Function (RT)

CheckInstanceOf Function (RT)

ClassCount Function (RT)

ClassList Function (RT)

ClassName Function (RT)

ClassTree Function (RT)

ClassTreeClass Function (RT)

cls Function (RT)

CMonth Function (RT)

Col Function (RT)

Collect Function (RT)

CollectCount Function (RT)

CollectForced Function (RT)

ConcatAtom Function (RT)

ConcatAtom3 Function (RT)

ConcatAtom4 Function (RT)

ConcatAtom5 Function (RT)

ConDate Function (RT)

Cos Function (RT)

Cot Function (RT)

CParamCount Function (RT)

CreateInstance Function (RT)

CSend Function (RT)

CToD Function (RT)

CToDAnsi Function (RT)

Date Function (RT)

Date2Bin Function (RT)

Day Function (RT)

DbApp Function (RT)

DbAppDelim Function (RT)

DbAppend Function (RT)

DbAppSdf Function (RT)

DbAutoLock Function (RT)

DbAutoLockArea Function (RT)

DbAutoUnLock Function (RT)

DbAutoUnLockArea Function (RT)

DbBlobInfo Function (RT)

DbBuffRefresh Function (RT)

DbClearFilter Function (RT)

DbClearIndex Function (RT)

DBClearOrderCondition Function (RT)

DbClearRelation Function (RT)

DbClearScope Function (RT)

DbCloseAll Function (RT)

DbCloseArea Function (RT)

DbCommit Function (RT)

DbCommitAll Function (RT)

DbContinue Function (RT)

DbCopy Function (RT)

DbCopyDelim Function (RT)

DbCopySDF Function (RT)

DbCopyStruct Function (RT)

DbCopyXStruct Function (RT)

DbCreate Function (RT)

DbCreateIndex Function (RT)

DbCreateOrder Function (RT)

DbDelete Function (RT)

DbDeleteOrder Function (RT)

DbDriver Function (RT)

DbEval Function (RT)

DBF Function (RT)

DbFieldInfo Function (RT)

DBFileCopy Function (RT)

DbFilter Function (RT)

DbGetSelect Function (RT)

DbGoBottom Function (RT)

DbGoto Function (RT)

DbGoTop Function (RT)

DbInfo Function (RT)

DbJoin Function (RT)

DbJoinAppend Function (RT)

DbLocate Function (RT)

DbMemoExt Function (RT)

DbMemoField Function (RT)

DbOrderInfo Function (RT)

DbPack Function (RT)

DbRecall Function (RT)

DbRecordInfo Function (RT)

DbReindex Function (RT)

DbRelation Function (RT)

DbRLock Function (RT)

DbRLockList Function (RT)

DbRSelect Function (RT)

DbRUnLock Function (RT)

DbScope Function (RT)

DbSeek Function (RT)

DbSelect Function (RT)

DbSelectArea Function (RT)

DbSetDriver Function (RT)

DbSetFilter Function (RT)

DbSetFound Function (RT)

DbSetIndex Function (RT)

DbSetOrder Function (RT)

DbSetOrderCondition Function (RT)

DbSetRelation Function (RT)

DbSetScope Function (RT)

DbSetSelect Function (RT)

DbSkip Function (RT)

DbSort Function (RT)

DbStruct Function (RT)

DbSymSelect Function (RT)

DbTotal Function (RT)

DbTrans Function (RT)

DbUnLock Function (RT)

DbUnLockAll Function (RT)

DbUpdate Function (RT)

DbUseArea Function (RT)

DbZap Function (RT)

DebOut Function (RT)

Default Function (RT)

Deleted Function (RT)

Descend Function (RT)

DescendA Function (RT)

DirChange Function (RT)

Directory Function (RT)

DirMake Function (RT)

DirRemove Function (RT)

DiskChange Function (RT)

DoError Function (RT)

DoW Function (RT)

DOY Function (RT)

DToC Function (RT)

DToR Function (RT)

DToS Function (RT)

Empty Function (RT)

EmptyField Function (RT)

EmptyPSZ Function (RT)

EmptyRecord Function (RT)

EmptyString Function (RT)

EmptyUsual Function (RT)

EnableArrayIndexCheck Function (RT)

EnableLBOptimizations Function (RT)

EnforceNumeric Function (RT)

EnforceType Function (RT)

Eof Function (RT)

ErrorBlock Function (RT)

ErrorExec Function (RT)

ErrorSys Function (RT)

Eval Function (RT)

Evaluate Function (RT)

ExecScript Function (RT)

ExecScriptFast Function (RT)

Exp Function (RT)

F2Bin Function (RT)

Fact Function (RT)

FCount Function (RT)

FieldBlock Function (RT)

FieldBlockSym Function (RT)

FieldGet Function (RT)

FieldGetAlias Function (RT)

FieldGetArea Function (RT)

FieldGetBytes Function (RT)

FieldGetSelect Function (RT)

FieldGetSym Function (RT)

FieldName Function (RT)

FieldPos Function (RT)

FieldPosSym Function (RT)

FieldPut Function (RT)

FieldPutAlias Function (RT)

FieldPutArea Function (RT)

FieldPutBytes Function (RT)

FieldPutSelect Function (RT)

FieldPutSym Function (RT)

FieldSym Function (RT)

FieldWBlock Function (RT)

FieldWBlockSym Function (RT)

FindClass Function (RT)

Float2Long Function (RT)

FloatFormat Function (RT)

Flock Function (RT)

Floor Function (RT)

Found Function (RT)

FParamCount Function (RT)

Frac Function (RT)

FRead Function (RT)

FRead3 Function (RT)

FRead4 Function (RT)

FReadLine Function (RT)

FReadText3 Function (RT)

FSeek Function (RT)

FWrite Function (RT)

FWrite3 Function (RT)

FWriteLine Function (RT)

FWriteText Function (RT)

GetColor Function (RT)

GetRTFullPath Function (RT)

GetThreadCount Function (RT)

GetTickCountLow Function (RT)

Header Function (RT)

InCollect Function (RT)

IndexCount Function (RT)

IndexExt Function (RT)

IndexHPLock Function (RT)

IndexKey Function (RT)

IndexOrd Function (RT)

InList Function (RT)

InListExact Function (RT)

Integer Function (RT)

IsAccess Function (RT)

IsArray Function (RT)

IsAssign Function (RT)

IsBinary Function (RT)

IsByRef Function (RT)

IsClass Function (RT)

IsClassOf Function (RT)

IsCodeBlock Function (RT)

IsCurrency Function (RT)

IsDate Function (RT)

IsDateTime Function (RT)

IsDecimal Function (RT)

IsFloat Function (RT)

IsFractional Function (RT)

IsInstanceOf Function (RT)

IsInstanceOfUsual Function (RT)

IsInt64 Function (RT)

IsInteger Function (RT)

IsLogic Function (RT)

IsLong Function (RT)

IsMethod Function (RT)

IsMethodClass Function (RT)

IsMethodUsual Function (RT)

IsNil Function (RT)

IsNumeric Function (RT)

IsObject Function (RT)

IsPtr Function (RT)

IsString Function (RT)

IsSymbol Function (RT)

IVarGet Function (RT)

IVarGetInfo Function (RT)

IVarGetSelf Function (RT)

IvarList Function (RT)

IvarListClass Function (RT)

IVarPut Function (RT)

IVarPutInfo Function (RT)

IVarPutSelf Function (RT)

JCDOW Function (RT)

JCMONTH Function (RT)

JCYEAR Function (RT)

LastRec Function (RT)

Len Function (RT)

LOG Function (RT)

Log10 Function (RT)

LUpdate Function (RT)

MAssign Function (RT)

Max Function (RT)

MaxAtom Function (RT)

MCompile Function (RT)

Mem2String Function (RT)

MemAlloc Function (RT)

MemAtSpecial Function (RT)

MemByte Function (RT)

MemCAlloc Function (RT)

MemChr Function (RT)

MemClear Function (RT)

MemComp Function (RT)

MemCopy Function (RT)

MemCopyString Function (RT)

MemDWord Function (RT)

MemFree Function (RT)

MemGrpAlloc Function (RT)

MemGrpCAlloc Function (RT)

MemGrpClose Function (RT)

MemGrpEnum Function (RT)

MemGrpOpen Function (RT)

MemInt Function (RT)

MemLen Function (RT)

MemLong Function (RT)

MemLower Function (RT)

MemMove Function (RT)

MemoTran Function (RT)

MemRealloc Function (RT)

MemSet Function (RT)

MemShort Function (RT)

MemTotal Function (RT)

MemTrace Function (RT)

MemUpper Function (RT)

MemVarBlock Function (RT)

MemVarBlockSym Function (RT)

MemVarClear Function (RT)

MemVarGet Function (RT)

MemVarGetSym Function (RT)

MemVarPut Function (RT)

MemVarPutSym Function (RT)

MemVarRelease Function (RT)

MemVarTryGet Function (RT)

MemWalk Function (RT)

MemWord Function (RT)

MethodList Function

MethodListClass Function

MExec Function (RT)

Min Function (RT)

MLCount Function (RT)

MLcToPos Function (RT)

MLPos Function (RT)

Mod Function (RT)

Month Function (RT)

MParamCount Function (RT)

MPosToLc Function (RT)

NewIndexLock Function (RT)

NewLocks Function (RT)

NoMethod Function (RT)

NTrim Function (RT)

Object2Array Function (RT)

Object2Float Function (RT)

Oem2AnsiBuff Function (RT)

OOPTree Function (RT)

OOPTreeClass Function (RT)

OrdBagExt Function (RT)

OrdBagName Function (RT)

OrdCondSet Function (RT)

OrdCount Function (RT)

OrdCreate Function (RT)

OrdDescend Function (RT)

OrdDestroy Function (RT)

OrdFor Function (RT)

OrdIsUnique Function (RT)

OrdKey Function (RT)

OrdKeyAdd Function (RT)

OrdKeyCount Function (RT)

OrdKeyDel Function (RT)

OrdKeyGoto Function (RT)

OrdKeyNo Function (RT)

OrdKeyVal Function (RT)

OrdList Function (RT)

OrdListAdd Function (RT)

OrdListClear Function (RT)

OrdListRebuild Function (RT)

OrdName Function (RT)

OrdNumber Function (RT)

OrdScope Function (RT)

OrdSetFocus Function (RT)

OrdSetRelation Function (RT)

OrdSkipUnique Function (RT)

Pad Function (RT)

PadC Function (RT)

PadL Function (RT)

PadR Function (RT)

PaletteRGB Function (RT)

Pause Function (RT)

PI Function (RT)

Pow Function (RT)

Psz2String Function (RT)

Psz2Usual Function (RT)

PszAlloc Function (RT)

PszLen Function (RT)

QOut Function (RT)

QQOut Function (RT)

Rand Function (RT)

RddCount Function (RT)

RddInfo Function (RT)

RddList Function (RT)

RddName Function (RT)

RddSetDefault Function (RT)

RddVersion Function (RT)

RecCount Function (RT)

RecNo Function (RT)

RecSize Function (RT)

RegisterAxit Function (RT)

RLock Function (RT)

Round Function (RT)

Row Function (RT)

RToD Function (RT)

Select Function (RT)

Send Function (RT)

Set Function (RT)

SetAlternate Function (RT)

SetAltFile Function (RT)

SetColor Function (RT)

SetConsole Function (RT)

SetFDateTime Function (RT)

SetFloatDelta Function (RT)

SetPos Function (RT)

SetTextFile Function (RT)

SetTextOutPut Function (RT)

SEval Function (RT)

SEvalA Function (RT)

ShowArray Function (RT)

ShowObject Function (RT)

ShowPrivates Function (RT)

ShowPublics Function (RT)

Sin Function (RT)

SplitPath Function (RT)

SQrt Function (RT)

SToD Function (RT)

Str Function (RT)

Str1 Function (RT)

Str2 Function (RT)

Str3 Function (RT)

StrEvaluate Function (RT)

StrFloat Function (RT)

String2Atom Function (RT)

String2Symbol Function (RT)

StringAlloc Function (RT)

StrInt Function (RT)

StrLong Function (RT)

StrToFloat Function (RT)

StrTran Function (RT)

StrZero Function (RT)

SubS Function (RT)

SubStr Function (RT)

Symbol2String Function (RT)

SysAddAtom Function (RT)

SysAddAtomUpperA Function (RT)

SysCompAtom Function (RT)

SysFindAtom Function (RT)

SysGetAtomName Function (RT)

Tan Function (RT)

TimePsz Function (RT)

TimePsz24 Function (RT)

Today Function (RT)

Tone Function (RT)

ToWord Function (RT)

Transform Function (RT)

TString Function (RT)

Type Function (RT)

Unformat Function (RT)

UnRegisterAxit Function (RT)

Used Function (RT)

UsualType Function (RT)

UsualVal Function (RT)

Val Function (RT)

ValType Function (RT)

VarGet Function (RT)

VarGetSym Function (RT)

VarPut Function (RT)

VarPutSym Function (RT)

Version Function (RT)

VoDbAlias Function (RT)

VoDbAliasSym Function (RT)

VoDbAppend Function (RT)

VoDbBlobInfo Function (RT)

VoDbBof Function (RT)

VoDbBuffRefresh Function (RT)

VoDbClearFilter Function (RT)

VoDbClearLocate Function (RT)

VoDbClearRelation Function (RT)

VoDbClearScope Function (RT)

VoDbCloseAll Function (RT)

VoDbCloseArea Function (RT)

VoDbCommit Function (RT)

VoDbCommitAll Function (RT)

VoDbContinue Function (RT)

VoDbCreate Function (RT)

VoDbDelete Function (RT)

VoDbDeleted Function (RT)

VoDbEof Function (RT)

VoDbEval Function (RT)

VoDbFieldGet Function (RT)

VoDbFieldGetBytes Function (RT)

VoDbFieldInfo Function (RT)

VoDbFieldPut Function (RT)

VoDbFieldPutBytes Function (RT)

VoDbFileGet Function (RT)

VoDbFilePut Function (RT)

VoDbFilter Function (RT)

VoDbFlock Function (RT)

VoDbFound Function (RT)

VoDbGetScope Function (RT)

VoDbGetSelect Function (RT)

VoDbGoBottom Function (RT)

VoDbGoto Function (RT)

VoDbGoTop Function (RT)

VoDbInfo Function (RT)

VoDbJoinAppend Function (RT)

VoDbLastRec Function (RT)

VoDbLocate Function (RT)

VoDbMemoExt Function (RT)

VoDbOrdBagExt Function (RT)

VoDbOrdCondSet Function (RT)

VoDbOrdCreate Function (RT)

VoDbOrdDestroy Function (RT)

VoDbOrderInfo Function (RT)

VoDbOrdListAdd Function (RT)

VoDbOrdListClear Function (RT)

VoDbOrdListRebuild Function (RT)

VoDbOrdSetFocus Function (RT)

VoDbPack Function (RT)

VoDbRddCount Function (RT)

VoDbRddInfo Function (RT)

VoDbRddList Function (RT)

VoDbRddName Function (RT)

VoDbRddSetDefault Function (RT)

VoDbRecall Function (RT)

VoDbRecno Function (RT)

VoDbRecordGet Function (RT)

VoDbRecordInfo Function (RT)

VoDbRecordPut Function (RT)

VoDbRelation Function (RT)

VoDbRlock Function (RT)

VoDbRSelect Function (RT)

VoDbSeek Function (RT)

VoDbSelect Function (RT)

VoDbSetFilter Function (RT)

VoDbSetFound Function (RT)

VoDbSetLocate Function (RT)

VoDbSetRelation Function (RT)

VoDbSetScope Function (RT)

VoDbSetSelect Function (RT)

VoDbSkip Function (RT)

VoDbSkipScope Function (RT)

VoDbSort Function (RT)

VoDbSymSelect Function (RT)

VoDbTrans Function (RT)

VoDbTransRec Function (RT)

VoDbUnlock Function (RT)

VoDbUnLockAll Function (RT)

VoDbUseArea Function (RT)

VoDbZap Function (RT)

XSharpLoadLibrary Function (RT)

Year Function (RT)

Click or drag to resize

DbUpdate Function

Replace fields in the current work area with values from another work area, based on the specified key expression.

Namespace: XSharp.RT
Assembly: XSharp.RT (in XSharp.RT.dll) Version: 2.21

Syntax

 FUNCTION DbUpdate(
	cAlias,
	cbKey,
	lRand,
	cbReplace
) AS LOGIC CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public static bool DbUpdate(
	Usual cAlias = default,
	Usual cbKey = default,
	Usual lRand = default,
	Usual cbReplace = default
)

Request Example View Source

Parameters

cAlias (Optional): Type: Usual
The alias identifier for the source work area used to update records in the current work area.
If there is no open database file associated with the specified alias, a runtime error is raised.
cbKey (Optional): Type: Usual
A code block defining the expression that defines matching records in the source work area.
lRand (Optional): Type: Usual
Random access flag.
If TRUE, the current work area must be ordered (using an index order) by cbKey but the source work area records can be in any order.
If FALSE, both the current work area and the source work area must be ordered (logically or physically) by Eval(cbKey).
cbReplace (Optional): Type: Usual
A code block defining how fields in the current work area should be replaced.

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE.

Remarks

For a shared database, DBUpdate() requires a file lock on the current database file.
The source database file can be open in any mode. DBUpdate() is the functional equivalent of the UPDATE command.

Tip
Deleted records: If SetDeleted() is FALSE, deleted records in both source files are processed. Records in the file being updated retain their deleted status and are not affected by the deleted status of records in the source file. If SetDeleted()is TRUE, however, no deleted records are processed from either source file

Examples

The following example updates the current work area from the TEST2 database (note the condition imposed by the bReplace evaluation):

X#

1DBUpdate("test2", {||Last},, ;
2                {||_FIELD->Salary := 0.00})

See Also

Reference

Functions, Globals and Defines

XSharp.RT Namespace

DBServer:Update

DbUpdate(Usual, Usual, Usual, Usual)

Copyright © 2015-2024 XSharp BV, All rights reserved. The VO SDK classes are Copyright © Computer Associates.

Send comments on this topic to info@xsharp.eu