Functions

Initialization & Finalization Routines:

Utility Functions:

function IsBlankAlpha(X: String): Boolean;

function IsBlankShort(X: Integer): Boolean;

function IsBlankLong(X: Longint): Boolean;

function IsBlankDate(X: TDate): Boolean;

function IsBlankDouble(X: Double): Boolean;

procedure BlankDouble(var X: Double);

Table Functions:

function PXTblOpen(TblName, TblHandle, IndexID, SaveEveryChange) : Integer;

function PXTblClose(TblHandle) : Integer;

function PXTblCreateMode(Mode) : Integer;

function PXTblCreate(TblName, NFields, Fields, Types) : Integer;

function PXTblEmpty(TblName) : Integer;

function PXTblDelete(TblName) : Integer;

function PXTblCopy(FromName, ToName) : Integer;

function PXTblRename(FromName, ToName) : Integer;

function PXTblAdd(SrcName, DestName) : Integer;

function PXTblUpgrade(TblHandle) : Integer;

Record Functions:

function PXRecAppend(TblHandle, RecHandle) : Integer;

function PXRecInsert(TblHandle, RecHandle) : Integer;

function PXRecUpdate(TblHandle, RecHandle) : Integer;

function PXRecDelete(TblHandle) : Integer;

function PXRecBufOpen(TblHandle, RecHandle) : Integer;

function PXRecBufClose(RecHandle) : Integer;

function PXRecBufEmpty(RecHandle) : Integer;

function PXRecBufCopy(Fromhandle, ToHandle) : Integer;

function PXRecGet(TblHandle, RecHandle) : Integer;

Field Functions:

function PXPutShort(RecHandle, FldHandle, Value) : Integer;

function PXPutDoub(RecHandle, FldHandle, Value) : Integer;

function PXPutLong(RecHandle, FldHandle, Value) : Integer;

function PXPutAlpha(RecHandle, FldHandle, Value) : Integer;

function PXPutDate(RecHandle, FldHandle, Value) : Integer;

function PXPutBlank(RecHandle, FldHandle) : Integer;

function PXGetShort(RecHandle, FldHandle, SValue) : Integer;

function PXGetDoub(RecHandle, FldHandle, DValue) : Integer;

function PXGetLong(RecHandle, FldHandle, LValue) : Integer;

function PXGetAlpha(RecHandle, FldHandle, Dest) : Integer;

function PXGetDate(RecHandle, FldHandle, Value) : Integer;

function PXFldBlank(RecHandle, FldHandle, Blank) : Integer;

function PXRecGoto(TblHandle, RecNum) : Integer;

function PXRecFirst(TblHandle) : Integer;

function PXRecLast(TblHandle) : Integer;

function PXRecNext(TblHandle) : Integer;

function PXRecPrev(TblHandle) : Integer;

Index Functions:

function PXKeyAdd(TblName, NFlds, FldHandles, Mode) : Integer;

function PXKeyDrop(TblName, IndexID) : Integer;

Date Function:

function PXDateDecode(aDate, Mo, Da, Yr) : Integer;

function PXDateEncode(Mo, Da, Yr, aDate) : Integer;

Search Functions:

function PXSrchKey(TblHandle, RecHandle, NFlds, Mode) : Integer;

function PXSrchFld(TblHandle, RecHandle, FldHandle, Mode) : Integer;

Password Functions:

function PXTblProtected(TblName, Protected) : Integer;

function PXPswAdd(Password) : Integer;

function PXPswDel(Password) : Integer;

function PXTblEncrypt(TblName, Password) : Integer;

function PXTblDecrypt(TblName) : Integer;

Informational Functions:

function PXTblExist(TblName, Exist) : Integer;

function PXTblName(TblHandle, TblName) : Integer;

function PXRecNum(TblHandle, RecNum) : Integer;

function PXTblNRecs(TblHandle, NRecs) : Integer;

function PXRecNFlds(TblHandle, NFlds) : Integer;

function PXKeyNFlds(TblHandle, NKeyFlds) : Integer;

function PXFldHandle(TblHandle, FldName, FldHandle) : Integer;

function PXFldType(TblHandle, FldHandle, FldType) : Integer;

function PXFldName(TblHandle, FldHandle, FldName) : Integer;

Miscellaneous Functions:

function PXTblMaxSize(MaxTblSize) : Integer;

function PXSave: Integer;

Concurrency Functions:

function PXNetUserName(UserName) : Integer;

function PXNetFileLock(FileName, LockType) : Integer;

function PXNetFileUnlock(FieldName, LockType) : Integer;

function PXNetTblLock(TblHandle, LockType) : Integer;

function PXNetTblUnlock(TblHandle, LockType) : Integer;

function PXNetRecLock(TblHandle, LckHandle) : Integer;

function PXNetRecUnlock(TblHandle, LckHandle) : Integer;

function PXNetRecLocked(TblHandle, Locked) : Integer;

function PXNetRecGotoLock(TblHandle, LckHandle) : Integer;

function PXNetTblChanged(TblHandle, Changed) : Integer;

function PXNetTblRefresh(TblHandle) : Integer;

function PXNetErrUser(UserName) : Integer;

Raw Data Access Functions:

function PXRawGet(RecHandle, Buffer, BufSize) : Integer;

function PXRawPut(RecHandle, Buffer, BufSize) : Integer;

Composite Index Functions:

function PXKeyMap(TblName, NFlds, FldHandles, FldName, Mode, IndexID) : Int;

function PXKeyQuery(IdxFileName,FldName,NFlds,Mode,FldHandles,IdxID) : Int;

Blob Functions:

function PXBlobOpenRead(RecHandle, FldHandle, BlbHandle) : Integer;

function PXBlobOpenWrite(RecHandle,FldHandle,BlbHandle,Size,SaveCurrent):Int;

function PXBlobClose(BlbHandle, Accept) : Integer;

function PXBlobDrop(RecHandle, FldHandle) : Integer;

function PXBlobGetSize(BlbHandle, Size) : Integer;

function PXBlobGet(BlbHandle, Size, Offset, Buffer) : Integer;

function PXBlobPut(BlbHandle, Size, Offset, Buffer) : Integer;

function PXBlobClone(RecHandle, FldHandle) : Integer;

function PXBlobQuickGet(RecHandle,FldHandle,BufSize,Dest,BytesRead) : Int;

Overlay Functions:

function PXLoadOverlay(OverlayName) : Integer;