3.2 HbConnection object
3.2.1 xHarbour functions
HbConnection.AClone - xHarbour function
|
Syntax:
|
AClone(<aSource>) -> aDuplicate
|
|
Parameters:
|
aSource | - Variant, array, in |
|
|
Return value:
|
aDuplicate - Variant, array
|
|
Top
|
|
|
HbConnection.ADir - xHarbour function
|
Syntax:
|
ADir(<cFilespec>, [<aFilenames>], [<aSizes>], [<aDates>], [<aTimes>], [<aAttributes>]) -> nFiles
|
|
Parameters:
|
cFilespec | - Character, in |
aFilenames | - Variant, array, in/out, optional |
aSizes | - Variant, array, in/out, optional |
aDates | - Variant, array, in/out, optional |
aTimes | - Variant, array, in/out, optional |
aAttributes | - Variant, array, in/out, optional |
|
|
Return value:
|
nFiles - Number
|
|
Top
|
|
|
HbConnection.AFields - xHarbour function
|
Syntax:
|
AFields([<aFieldNames>], [<aTypes>], [<aWidths>], [<aDecimals>]) -> nFields
|
|
Parameters:
|
aFieldNames | - Variant, array, in/out, optional |
aTypes | - Variant, array, in/out, optional |
aWidths | - Variant, array, in/out, optional |
aDecimals | - Variant, array, in/out, optional |
|
|
Return value:
|
nFields - Number
|
|
Top
|
|
|
HbConnection.AFill - xHarbour function
|
Syntax:
|
AFill(<aTarget>, <expValue>, [<nStart>], [<nCount>]) -> NIL
|
|
Parameters:
|
aTarget | - Variant, array, in/out |
expValue | - Variant, in |
nStart | - Number, in, optional |
nCount | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.AllTrim - xHarbour function
|
Syntax:
|
AllTrim(<cString>) -> cTrimString
|
|
Parameters:
|
|
|
Return value:
|
cTrimString - Character
|
|
Top
|
|
|
HbConnection.Array - xHarbour function
|
Syntax:
|
Array(<nElements1>, [<nElements2>], [<nElements3>], [<nElements4>], [<nElements5>]) -> aArray
|
|
Parameters:
|
nElements1 | - Number, in |
nElements2 | - Number, in, optional |
nElements3 | - Number, in, optional |
nElements4 | - Number, in, optional |
nElements5 | - Number, in, optional |
|
|
Return value:
|
aArray - Variant, array
|
|
Top
|
|
|
HbConnection.AScan - xHarbour function
|
Syntax:
|
AScan(<aTarget>, <expValue>, [<nStart>], [<nCount>]) -> nStoppedAt
|
|
Parameters:
|
aTarget | - Variant, array, in |
expValue | - Variant, in |
nStart | - Number, in, optional |
nCount | - Number, in, optional |
|
|
Return value:
|
nStoppedAt - Number
|
|
Top
|
|
|
HbConnection.ASort - xHarbour function
|
Syntax:
|
ASort(<aTarget>, [<nStart>], [<nCount>]) -> NIL
|
|
Parameters:
|
aTarget | - Variant, array, in/out |
nStart | - Number, in, optional |
nCount | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.CToD - xHarbour function
|
Syntax:
|
CToD(<cDate>) -> dDate
|
|
Parameters:
|
|
|
Return value:
|
dDate - Date
|
|
Top
|
|
|
HbConnection.CurDir - xHarbour function
|
Syntax:
|
CurDir([<cDriveSpec>]) -> cDirectory
|
|
Parameters:
|
cDriveSpec | - Character, in, optional |
|
|
Return value:
|
cDirectory - Character
|
|
Top
|
|
|
HbConnection.Date - xHarbour function
|
Syntax:
|
Date() -> dSysDate
|
|
Parameters:
|
|
|
Return value:
|
dSysDate - Date
|
|
Top
|
|
|
HbConnection.Day - xHarbour function
|
Syntax:
|
Day(<dDate>) -> nDay
|
|
Parameters:
|
|
|
Return value:
|
nDay - Number
|
|
Top
|
|
|
HbConnection.DbDrop - xHarbour function
|
Syntax:
|
DbDrop(<cTabName>, <cRDDName>) -> lSuccess
|
|
Parameters:
|
cTabName | - Character, in |
cRDDName | - Character, in |
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbConnection.DbExists - xHarbour function
|
Syntax:
|
DbExists(<cTabName>, <cIndexName>, <cRDDName>) -> lExists
|
|
Parameters:
|
cTabName | - Character, in |
cIndexName | - Character, in |
cRDDName | - Character, in |
|
|
Return value:
|
lExists - Logical
|
|
Top
|
|
|
HbConnection.DbUnlockAll - xHarbour function
|
Syntax:
|
DbUnlockAll() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.DirChange - xHarbour function
|
Syntax:
|
DirChange(<cDir>) -> nSuccess
|
|
Parameters:
|
|
|
Return value:
|
nSuccess - Number
|
|
Top
|
|
|
HbConnection.DirRemove - xHarbour function
|
Syntax:
|
DirRemove(<cDirName>) -> nSuccess
|
|
Parameters:
|
|
|
Return value:
|
nSuccess - Number
|
|
Top
|
|
|
HbConnection.DiskChange - xHarbour function
|
Syntax:
|
DiskChange(<cDrive>) -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbConnection.DiskName - xHarbour function
|
Syntax:
|
DiskName() -> cDrive
|
|
Parameters:
|
|
|
Return value:
|
cDrive - Character
|
|
Top
|
|
|
HbConnection.DiskSpace - xHarbour function
|
Syntax:
|
DiskSpace([<nDrive>]) -> nBytes
|
|
Parameters:
|
nDrive | - Number, in, optional |
|
|
Return value:
|
nBytes - Number
|
|
Top
|
|
|
HbConnection.DToC - xHarbour function
|
Syntax:
|
DToC(<dDate>) -> cDate
|
|
Parameters:
|
|
|
Return value:
|
cDate - Character
|
|
Top
|
|
|
HbConnection.DToS - xHarbour function
|
Syntax:
|
DToS(<dDate>) -> cDate
|
|
Parameters:
|
|
|
Return value:
|
cDate - Character
|
|
Top
|
|
|
HbConnection.Empty - xHarbour function
|
Syntax:
|
Empty(<uExp>) -> lEmpty
|
|
Parameters:
|
|
|
Return value:
|
lEmpty - Logical
|
|
Top
|
|
|
HbConnection.Exp - xHarbour function
|
Syntax:
|
Exp(<nExponent>) -> nAntilogarithm
|
|
Parameters:
|
|
|
Return value:
|
nAntilogarithm - Number
|
|
Top
|
|
|
HbConnection.FErase - xHarbour function
|
Syntax:
|
FErase(<cFile>) -> nSuccess
|
|
Parameters:
|
|
|
Return value:
|
nSuccess - Number
|
|
Top
|
|
|
HbConnection.File - xHarbour function
|
Syntax:
|
File(<cFilespec>) -> lExists
|
|
Parameters:
|
cFilespec | - Character, in |
|
|
Return value:
|
lExists - Logical
|
|
Top
|
|
|
HbConnection.Hb_LangSelect - xHarbour function
|
Syntax:
|
Hb_LangSelect(<cNewLangName>) -> cPrevLangName
|
|
Parameters:
|
cNewLangName | - Character, in |
|
|
Return value:
|
cPrevLangName - Character
|
|
Top
|
|
|
HbConnection.Hb_LibDo - xHarbour function
|
Syntax:
|
Hb_LibDo(<cFunName>, [<uPar1>], [<uPar2>], [<uPar3>]) -> uResult
|
|
Parameters:
|
cFunName | - Character, in |
uPar1 | - Variant, in, optional |
uPar2 | - Variant, in, optional |
uPar3 | - Variant, in, optional |
|
|
Return value:
|
uResult - Variant
|
|
Top
|
|
|
HbConnection.Hb_SetCodePage - xHarbour function
|
Syntax:
|
Hb_SetCodePage(<cNewCodePageName>) -> cPrevCodePageName
|
|
Parameters:
|
cNewCodePageName | - Character, in |
|
|
Return value:
|
cPrevCodePageName - Character
|
|
Top
|
|
|
HbConnection.Hb_Translate - xHarbour function
|
Syntax:
|
Hb_Translate(<cStrToTranslate>, <cCodePageIdFrom>, <cCodePageIdTo>) -> cStrTranslated
|
|
Parameters:
|
cStrToTranslate | - Character, in |
cCodePageIdFrom | - Character, in |
cCodePageIdTo | - Character, in |
|
|
Return value:
|
cStrTranslated - Character
|
|
Top
|
|
|
HbConnection.Int - xHarbour function
|
Syntax:
|
Int(<nExp>) -> nInteger
|
|
Parameters:
|
|
|
Return value:
|
nInteger - Number
|
|
Top
|
|
|
HbConnection.IsAlpha - xHarbour function
|
Syntax:
|
IsAlpha(<cString>) -> lBoolean
|
|
Parameters:
|
|
|
Return value:
|
lBoolean - Logical
|
|
Top
|
|
|
HbConnection.IsDigit - xHarbour function
|
Syntax:
|
IsDigit(<cString>) -> lBoolean
|
|
Parameters:
|
|
|
Return value:
|
lBoolean - Logical
|
|
Top
|
|
|
HbConnection.IsDisk - xHarbour function
|
Syntax:
|
IsDisk(<cDrive>) -> lAvailable
|
|
Parameters:
|
|
|
Return value:
|
lAvailable - Logical
|
|
Top
|
|
|
HbConnection.IsLower - xHarbour function
|
Syntax:
|
IsLower(<cString>) -> lBoolean
|
|
Parameters:
|
|
|
Return value:
|
lBoolean - Logical
|
|
Top
|
|
|
HbConnection.IsPrinter - xHarbour function
|
Syntax:
|
IsPrinter() -> lReady
|
|
Parameters:
|
|
|
Return value:
|
lReady - Logical
|
|
Top
|
|
|
HbConnection.IsUpper - xHarbour function
|
Syntax:
|
IsUpper(<cString>) -> lBoolean
|
|
Parameters:
|
|
|
Return value:
|
lBoolean - Logical
|
|
Top
|
|
|
HbConnection.Left - xHarbour function
|
Syntax:
|
Left(<cString>, <nCount>) -> cSubString
|
|
Parameters:
|
cString | - Character, in |
nCount | - Number, in |
|
|
Return value:
|
cSubString - Character
|
|
Top
|
|
|
HbConnection.Len - xHarbour function
|
Syntax:
|
Len(<cString>) -> nCount
|
|
Parameters:
|
|
|
Return value:
|
nCount - Number
|
|
Top
|
|
|
HbConnection.LibFree - xHarbour function
|
Syntax:
|
LibFree(<nHandle>) -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.LibLoad - xHarbour function
|
Syntax:
|
LibLoad(<cDllName>) -> nHandle
|
|
Parameters:
|
|
|
Return value:
|
nHandle - Number
|
|
Top
|
|
|
HbConnection.Log - xHarbour function
|
Syntax:
|
Log(<nExp>) -> nNaturalLog
|
|
Parameters:
|
|
|
Return value:
|
nNaturalLog - Number
|
|
Top
|
|
|
HbConnection.Lower - xHarbour function
|
Syntax:
|
Lower(<cString>) -> cLowerString
|
|
Parameters:
|
|
|
Return value:
|
cLowerString - Character
|
|
Top
|
|
|
HbConnection.LTrim - xHarbour function
|
Syntax:
|
LTrim(<cString>) -> cTrimString
|
|
Parameters:
|
|
|
Return value:
|
cTrimString - Character
|
|
Top
|
|
|
HbConnection.MakeDir - xHarbour function
|
Syntax:
|
MakeDir(<cNewDir>) -> nSuccess
|
|
Parameters:
|
|
|
Return value:
|
nSuccess - Number
|
|
Top
|
|
|
HbConnection.Month - xHarbour function
|
Syntax:
|
Month(<dDate>) -> nMonth
|
|
Parameters:
|
|
|
Return value:
|
nMonth - Number
|
|
Top
|
|
|
HbConnection.NetErr - xHarbour function
|
Syntax:
|
NetErr([<lNewError>]) -> lError
|
|
Parameters:
|
lNewError | - Logical, in, optional |
|
|
Return value:
|
lError - Logical
|
|
Top
|
|
|
HbConnection.PadC - xHarbour function
|
Syntax:
|
PadC(<uExp>, <nLength>, [<cFillChar>]) -> cPaddedString
|
|
Parameters:
|
uExp | - Variant, in |
nLength | - Number, in |
cFillChar | - Character, in, optional |
|
|
Return value:
|
cPaddedString - Character
|
|
Top
|
|
|
HbConnection.PadL - xHarbour function
|
Syntax:
|
PadL(<uExp>, <nLength>, [<cFillChar>]) -> cPaddedString
|
|
Parameters:
|
uExp | - Variant, in |
nLength | - Number, in |
cFillChar | - Character, in, optional |
|
|
Return value:
|
cPaddedString - Character
|
|
Top
|
|
|
HbConnection.PadR - xHarbour function
|
Syntax:
|
PadR(<uExp>, <nLength>, [<cFillChar>]) -> cPaddedString
|
|
Parameters:
|
uExp | - Variant, in |
nLength | - Number, in |
cFillChar | - Character, in, optional |
|
|
Return value:
|
cPaddedString - Character
|
|
Top
|
|
|
HbConnection.RddList - xHarbour function
|
Syntax:
|
RddList([<nRddType>]) -> aRddList
|
|
Parameters:
|
nRddType | - Number, in, optional |
|
|
Return value:
|
aRddList - Variant, array
|
|
Top
|
|
|
HbConnection.Replicate - xHarbour function
|
Syntax:
|
Replicate(<cString>, <nCount>) -> cRepeatedString
|
|
Parameters:
|
cString | - Character, in |
nCount | - Number, in |
|
|
Return value:
|
cRepeatedString - Character
|
|
Top
|
|
|
HbConnection.Right - xHarbour function
|
Syntax:
|
Right(<cString>, <nCount>) -> cSubString
|
|
Parameters:
|
cString | - Character, in |
nCount | - Number, in |
|
|
Return value:
|
cSubString - Character
|
|
Top
|
|
|
HbConnection.Round - xHarbour function
|
Syntax:
|
Round(<nNumber>, <nDecimals>) -> nRounded
|
|
Parameters:
|
nNumber | - Number, in |
nDecimals | - Number, in |
|
|
Return value:
|
nRounded - Number
|
|
Top
|
|
|
HbConnection.Seconds - xHarbour function
|
Syntax:
|
Seconds() -> nSeconds
|
|
Parameters:
|
|
|
Return value:
|
nSeconds - Number
|
|
Top
|
|
|
HbConnection.Set - xHarbour function
|
Syntax:
|
Set(<nSpecifier>, [<expNewSetting>], [<lOpenMode>]) -> uCurrentSetting
|
|
Parameters:
|
nSpecifier | - Number, in |
expNewSetting | - Variant, in, optional |
lOpenMode | - Logical, in, optional |
|
|
Return value:
|
uCurrentSetting - Variant
|
|
Top
|
|
|
HbConnection.Soundex - xHarbour function
|
Syntax:
|
Soundex(<cString>) -> cSoundexString
|
|
Parameters:
|
|
|
Return value:
|
cSoundexString - Character
|
|
Top
|
|
|
HbConnection.Space - xHarbour function
|
Syntax:
|
Space(<nCount>) -> cSpaces
|
|
Parameters:
|
|
|
Return value:
|
cSpaces - Character
|
|
Top
|
|
|
HbConnection.Sqrt - xHarbour function
|
Syntax:
|
Sqrt(<nNumber>) -> nRoot
|
|
Parameters:
|
|
|
Return value:
|
nRoot - Number
|
|
Top
|
|
|
HbConnection.Str - xHarbour function
|
Syntax:
|
Str(<nNumber>, [<nLength>], [<nDecimals>]) -> cNumber
|
|
Parameters:
|
nNumber | - Number, in |
nLength | - Number, in, optional |
nDecimals | - Number, in, optional |
|
|
Return value:
|
cNumber - Character
|
|
Top
|
|
|
HbConnection.StrTran - xHarbour function
|
Syntax:
|
StrTran(<cString>, <cSearch>, [<cReplace>], [<nStart>]) -> cNewString
|
|
Parameters:
|
cString | - Character, in |
cSearch | - Character, in |
cReplace | - Character, in, optional |
nStart | - Number, in, optional |
|
|
Return value:
|
cNewString - Character
|
|
Top
|
|
|
HbConnection.Stuff - xHarbour function
|
Syntax:
|
Stuff(<cString>, <nStart>, <nDelete>, <cInsert>) -> cNewString
|
|
Parameters:
|
cString | - Character, in |
nStart | - Number, in |
nDelete | - Number, in |
cInsert | - Character, in |
|
|
Return value:
|
cNewString - Character
|
|
Top
|
|
|
HbConnection.Substr - xHarbour function
|
Syntax:
|
Substr(<cString>, <nStart>, [<nCount>]) -> cSubString
|
|
Parameters:
|
cString | - Character, in |
nStart | - Number, in |
nCount | - Number, in, optional |
|
|
Return value:
|
cSubString - Character
|
|
Top
|
|
|
HbConnection.Time - xHarbour function
|
Syntax:
|
Time() -> cTimeString
|
|
Parameters:
|
|
|
Return value:
|
cTimeString - Character
|
|
Top
|
|
|
HbConnection.Transform - xHarbour function
|
Syntax:
|
Transform(<uExp>, <cSayPicture>) -> cFormatString
|
|
Parameters:
|
uExp | - Variant, in |
cSayPicture | - Character, in |
|
|
Return value:
|
cFormatString - Character
|
|
Top
|
|
|
HbConnection.Trim - xHarbour function
|
Syntax:
|
Trim(<cString>) -> cTrimString
|
|
Parameters:
|
|
|
Return value:
|
cTrimString - Character
|
|
Top
|
|
|
HbConnection.Upper - xHarbour function
|
Syntax:
|
Upper(<cString>) -> cUpperString
|
|
Parameters:
|
|
|
Return value:
|
cUpperString - Character
|
|
Top
|
|
|
HbConnection.Version - xHarbour function
|
Syntax:
|
Version() -> cVersion
|
|
Parameters:
|
|
|
Return value:
|
cVersion - Character
|
|
Top
|
|
|
HbConnection.Year - xHarbour function
|
Syntax:
|
Year(<dDate>) -> nYear
|
|
Parameters:
|
|
|
Return value:
|
nYear - Number
|
|
Top
|
|
|
3.2.2 Mediator functions
HbConnection.MedAppTmt - Mediator function
|
Syntax:
|
MedAppTmt([<nAppendTimeout>]) -> NIL
|
|
Parameters:
|
nAppendTimeout | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedChgPwd - Mediator function
|
Syntax:
|
MedChgPwd(<cOldPassword>, <cNewPassword>) -> nResult
|
|
Parameters:
|
cOldPassword | - Character, in |
cNewPassword | - Character, in |
|
|
Return value:
|
nResult - Number
|
|
Top
|
|
|
HbConnection.MedClntId - Mediator function
|
Syntax:
|
MedClntId() -> nClientConnectionId
|
|
Parameters:
|
|
|
Return value:
|
nClientConnectionId - Number
|
|
Top
|
|
|
HbConnection.MedClrTbCa - Mediator function
|
Syntax:
|
MedClrTbCa() -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbConnection.MedCltVBFx - Mediator function
|
Syntax:
|
MedCltVBFx() -> nClientBugFix
|
|
Parameters:
|
|
|
Return value:
|
nClientBugFix - Number
|
|
Top
|
|
|
HbConnection.MedCltVMaj - Mediator function
|
Syntax:
|
MedCltVMaj() -> nClientMajorVersion
|
|
Parameters:
|
|
|
Return value:
|
nClientMajorVersion - Number
|
|
Top
|
|
|
HbConnection.MedCltVMin - Mediator function
|
Syntax:
|
MedCltVMin() -> nClientMinorVersion
|
|
Parameters:
|
|
|
Return value:
|
nClientMinorVersion - Number
|
|
Top
|
|
|
HbConnection.MedCltVSub - Mediator function
|
Syntax:
|
MedCltVSub() -> nClientSubVersion
|
|
Parameters:
|
|
|
Return value:
|
nClientSubVersion - Number
|
|
Top
|
|
|
HbConnection.MedCmdRes - Mediator function
|
Syntax:
|
MedCmdRes() -> nSqlResult
|
|
Parameters:
|
|
|
Return value:
|
nSqlResult - Number
|
|
Top
|
|
|
HbConnection.MedDbCode - Mediator function
|
Syntax:
|
MedDbCode() -> nMedDatabaseCode
|
|
Parameters:
|
|
|
Return value:
|
nMedDatabaseCode - Number
|
|
Top
|
|
|
HbConnection.MedDbConn - Mediator function
|
Syntax:
|
MedDbConn() -> nDatabaseConnects
|
|
Parameters:
|
|
|
Return value:
|
nDatabaseConnects - Number
|
|
Top
|
|
|
HbConnection.MedDbName - Mediator function
|
Syntax:
|
MedDbName() -> cRDBMSName
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSName - Character
|
|
Top
|
|
|
HbConnection.MedDbsUser - Mediator function
|
Syntax:
|
MedDbsUser() -> cRDBMSUserName
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSUserName - Character
|
|
Top
|
|
|
HbConnection.MedDbVer - Mediator function
|
Syntax:
|
MedDbVer() -> cRDBMSVersion
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSVersion - Character
|
|
Top
|
|
|
HbConnection.MedDiscTm - Mediator function
|
Syntax:
|
MedDiscTm(<nDisconnectTimeout>) -> NIL
|
|
Parameters:
|
nDisconnectTimeout | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedDropTab - Mediator function
|
Syntax:
|
MedDropTab(<cTableName>) -> lResult
|
|
Parameters:
|
cTableName | - Character, in |
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.MedErrText - Mediator function
|
Syntax:
|
MedErrText() -> cRDBMSErrorText
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSErrorText - Character
|
|
Top
|
|
|
HbConnection.MedExecSQL - Mediator function
|
Syntax:
|
MedExecSQL(<cSQLStatement>) -> nCount
|
|
Parameters:
|
cSQLStatement | - Character, in |
|
|
Return value:
|
nCount - Number
|
|
Top
|
|
|
HbConnection.MedExRecc - Mediator function
|
Syntax:
|
MedExRecc(<lReccountMode>) -> NIL
|
|
Parameters:
|
lReccountMode | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedFErase - Mediator function
|
Syntax:
|
MedFErase(<cFile>) -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbConnection.MedFltRes - Mediator function
|
Syntax:
|
MedFltRes() -> nResult
|
|
Parameters:
|
|
|
Return value:
|
nResult - Number
|
|
Top
|
|
|
HbConnection.MedFTName - Mediator function
|
Syntax:
|
MedFTName() -> cFullTableName
|
|
Parameters:
|
|
|
Return value:
|
cFullTableName - Character
|
|
Top
|
|
|
HbConnection.MedHdSqlFl - Mediator function
|
Syntax:
|
MedHdSqlFl(<lHideSQLFilterText>) -> NIL
|
|
Parameters:
|
lHideSQLFilterText | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedIdxLen - Mediator function
|
Syntax:
|
MedIdxLen(<nIndexLength>) -> NIL
|
|
Parameters:
|
nIndexLength | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedIsBag - Mediator function
|
Syntax:
|
MedIsBag(<cTableName>, <cBagName>) -> lResult
|
|
Parameters:
|
cTableName | - Character, in |
cBagName | - Character, in |
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.MedIsIdx - Mediator function
|
Syntax:
|
MedIsIdx(<cTableName>, <cIndex>, [<cBagName>]) -> lResult
|
|
Parameters:
|
cTableName | - Character, in |
cIndex | - Character, in |
cBagName | - Character, in, optional |
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.MedIsTable - Mediator function
|
Syntax:
|
MedIsTable(<cTable>) -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.MedIsTr - Mediator function
|
Syntax:
|
MedIsTr() -> lIsTransaction
|
|
Parameters:
|
|
|
Return value:
|
lIsTransaction - Logical
|
|
Top
|
|
|
HbConnection.MedLgMsg - Mediator function
|
Syntax:
|
MedLgMsg(<nLogErrNum>) -> cErrMessage
|
|
Parameters:
|
|
|
Return value:
|
cErrMessage - Character
|
|
Top
|
|
|
HbConnection.MedLMCnAct - Mediator function
|
Syntax:
|
MedLMCnAct() -> nLMActiveConnections
|
|
Parameters:
|
|
|
Return value:
|
nLMActiveConnections - Number
|
|
Top
|
|
|
HbConnection.MedLMCnSet - Mediator function
|
Syntax:
|
MedLMCnSet() -> nLMNumberConnections
|
|
Parameters:
|
|
|
Return value:
|
nLMNumberConnections - Number
|
|
Top
|
|
|
HbConnection.MedLMGRecc - Mediator function
|
Syntax:
|
MedLMGRecc(<lReccountMode>) -> NIL
|
|
Parameters:
|
lReccountMode | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedLMMode - Mediator function
|
Syntax:
|
MedLMMode() -> lLockManagerMode
|
|
Parameters:
|
|
|
Return value:
|
lLockManagerMode - Logical
|
|
Top
|
|
|
HbConnection.MedLockItv - Mediator function
|
Syntax:
|
MedLockItv(<nTryInterval>) -> NIL
|
|
Parameters:
|
nTryInterval | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedLockTry - Mediator function
|
Syntax:
|
MedLockTry(<nTryCount>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedLogAsN2 - Mediator function
|
Syntax:
|
MedLogAsN2(<lPrevSetting>) -> lLogicalFieldsAsN2
|
|
Parameters:
|
lPrevSetting | - Logical, in |
|
|
Return value:
|
lLogicalFieldsAsN2 - Logical
|
|
Top
|
|
|
HbConnection.MedLogErr - Mediator function
|
Syntax:
|
MedLogErr(<nLoginErrorCode>) -> NIL
|
|
Parameters:
|
nLoginErrorCode | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedLogged - Mediator function
|
Syntax:
|
MedLogged() -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbConnection.MedLogin - Mediator function
|
Syntax:
|
MedLogin(<cMedNodeAddr>, <cMedSocket>, <cMedUser>, <cMedPasswd>, <cMedCS>) -> nResult
|
|
Parameters:
|
cMedNodeAddr | - Character, in |
cMedSocket | - Character, in |
cMedUser | - Character, in |
cMedPasswd | - Character, in |
cMedCS | - Character, in |
|
|
Return value:
|
nResult - Number
|
|
Top
|
|
|
HbConnection.MedLogout - Mediator function
|
Syntax:
|
MedLogout() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedLogTVal - Mediator function
|
Syntax:
|
MedLogTVal(<nTrueValue>) -> nPreviousTVal
|
|
Parameters:
|
|
|
Return value:
|
nPreviousTVal - Number
|
|
Top
|
|
|
HbConnection.MedMaxLic - Mediator function
|
Syntax:
|
MedMaxLic() -> nMaxLicences
|
|
Parameters:
|
|
|
Return value:
|
nMaxLicences - Number
|
|
Top
|
|
|
HbConnection.MedMedVBfx - Mediator function
|
Syntax:
|
MedMedVBfx() -> nMediatorBugFix
|
|
Parameters:
|
|
|
Return value:
|
nMediatorBugFix - Number
|
|
Top
|
|
|
HbConnection.MedMedVMaj - Mediator function
|
Syntax:
|
MedMedVMaj() -> nMediatorMajorVersion
|
|
Parameters:
|
|
|
Return value:
|
nMediatorMajorVersion - Number
|
|
Top
|
|
|
HbConnection.MedMedVMin - Mediator function
|
Syntax:
|
MedMedVMin() -> nMediatorMinorVersion
|
|
Parameters:
|
|
|
Return value:
|
nMediatorMinorVersion - Number
|
|
Top
|
|
|
HbConnection.MedMedVSub - Mediator function
|
Syntax:
|
MedMedVSub() -> nMediatorSubVersion
|
|
Parameters:
|
|
|
Return value:
|
nMediatorSubVersion - Number
|
|
Top
|
|
|
HbConnection.MedMemType - Mediator function
|
Syntax:
|
MedMemType(<nMemoType>) -> nPrevMemoType
|
|
Parameters:
|
|
|
Return value:
|
nPrevMemoType - Number
|
|
Top
|
|
|
HbConnection.MedNulChar - Mediator function
|
Syntax:
|
MedNulChar() -> cRDBMSNullCharacter
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSNullCharacter - Character
|
|
Top
|
|
|
HbConnection.MedNulDate - Mediator function
|
Syntax:
|
MedNulDate() -> cRDBMSNulldate
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSNulldate - Character
|
|
Top
|
|
|
HbConnection.MedRddUser - Mediator function
|
Syntax:
|
MedRddUser() -> cRddUserName
|
|
Parameters:
|
|
|
Return value:
|
cRddUserName - Character
|
|
Top
|
|
|
HbConnection.MedRenTab - Mediator function
|
Syntax:
|
MedRenTab(<cOldName>, <cNewName>) -> NIL
|
|
Parameters:
|
cOldName | - Character, in |
cNewName | - Character, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedRfsRecA - Mediator function
|
Syntax:
|
MedRfsRecA([<nRefreshFlags>]) -> nPreviousFlags
|
|
Parameters:
|
nRefreshFlags | - Number, in, optional |
|
|
Return value:
|
nPreviousFlags - Number
|
|
Top
|
|
|
HbConnection.MedSelVal - Mediator function
|
Syntax:
|
MedSelVal(<cSQLStatement>, [<nPrecision>]) -> uValue
|
|
Parameters:
|
cSQLStatement | - Character, in |
nPrecision | - Number, in, optional |
|
|
Return value:
|
uValue - Variant
|
|
Top
|
|
|
HbConnection.MedSessId - Mediator function
|
Syntax:
|
MedSessId() -> nMediatorSessionId
|
|
Parameters:
|
|
|
Return value:
|
nMediatorSessionId - Number
|
|
Top
|
|
|
HbConnection.MedSetCPC - Mediator function
|
Syntax:
|
MedSetCPC(<nClientCodePage>) -> NIL
|
|
Parameters:
|
nClientCodePage | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSetCPS - Mediator function
|
Syntax:
|
MedSetCPS(<nServerCodePage>) -> NIL
|
|
Parameters:
|
nServerCodePage | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSetFltS - Mediator function
|
Syntax:
|
MedSetFltS(<nFilteringMode>) -> NIL
|
|
Parameters:
|
nFilteringMode | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSetPerf - Mediator function
|
Syntax:
|
MedSetPerf(<lNewMode>) -> lPreviousMode
|
|
Parameters:
|
|
|
Return value:
|
lPreviousMode - Logical
|
|
Top
|
|
|
HbConnection.MedSetQP - Mediator function
|
Syntax:
|
MedSetQP(<nDefltQueryPrecision>) -> NIL
|
|
Parameters:
|
nDefltQueryPrecision | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSetSQLE - Mediator function
|
Syntax:
|
MedSetSQLE(<nSQLErrorMode>) -> NIL
|
|
Parameters:
|
nSQLErrorMode | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSqlPar - Mediator function
|
Syntax:
|
MedSqlPar(<uSqlP1>, [<uSqlP2>], [<uSqlP3>], [<uSqlP4>], [<uSqlP5>]) -> NIL
|
|
Parameters:
|
uSqlP1 | - Variant, in |
uSqlP2 | - Variant, in, optional |
uSqlP3 | - Variant, in, optional |
uSqlP4 | - Variant, in, optional |
uSqlP5 | - Variant, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSqlParA - Mediator function
|
Syntax:
|
MedSqlParA(<aSqlPars>) -> NIL
|
|
Parameters:
|
aSqlPars | - Variant, array, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedSrvDate - Mediator function
|
Syntax:
|
MedSrvDate(<dDate>) -> cRDBMSDateString
|
|
Parameters:
|
|
|
Return value:
|
cRDBMSDateString - Character
|
|
Top
|
|
|
HbConnection.MedSrvDay - Mediator function
|
Syntax:
|
MedSrvDay() -> nMediatorServerDay
|
|
Parameters:
|
|
|
Return value:
|
nMediatorServerDay - Number
|
|
Top
|
|
|
HbConnection.MedSrvMnth - Mediator function
|
Syntax:
|
MedSrvMnth() -> nMediatorServerMonth
|
|
Parameters:
|
|
|
Return value:
|
nMediatorServerMonth - Number
|
|
Top
|
|
|
HbConnection.MedSrvSys - Mediator function
|
Syntax:
|
MedSrvSys() -> nServerOperatingSystem
|
|
Parameters:
|
|
|
Return value:
|
nServerOperatingSystem - Number
|
|
Top
|
|
|
HbConnection.MedSrvVMaj - Mediator function
|
Syntax:
|
MedSrvVMaj() -> nServerMajorVersion
|
|
Parameters:
|
|
|
Return value:
|
nServerMajorVersion - Number
|
|
Top
|
|
|
HbConnection.MedSrvVMin - Mediator function
|
Syntax:
|
MedSrvVMin() -> nServerMinorVersion
|
|
Parameters:
|
|
|
Return value:
|
nServerMinorVersion - Number
|
|
Top
|
|
|
HbConnection.MedSrvYear - Mediator function
|
Syntax:
|
MedSrvYear() -> nMediatorServerYear
|
|
Parameters:
|
|
|
Return value:
|
nMediatorServerYear - Number
|
|
Top
|
|
|
HbConnection.MedStReset - Mediator function
|
Syntax:
|
MedStReset() -> cDumpFileName
|
|
Parameters:
|
|
|
Return value:
|
cDumpFileName - Character
|
|
Top
|
|
|
HbConnection.MedStStart - Mediator function
|
Syntax:
|
MedStStart() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedStStop - Mediator function
|
Syntax:
|
MedStStop() -> cDumpFileName
|
|
Parameters:
|
|
|
Return value:
|
cDumpFileName - Character
|
|
Top
|
|
|
HbConnection.MedTrBegin - Mediator function
|
Syntax:
|
MedTrBegin([<nTimeout>]) -> NIL
|
|
Parameters:
|
nTimeout | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedTrComm - Mediator function
|
Syntax:
|
MedTrComm() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MedTrMode - Mediator function
|
Syntax:
|
MedTrMode(<nNewTrMode>) -> nPreviousTrMode
|
|
Parameters:
|
|
|
Return value:
|
nPreviousTrMode - Number
|
|
Top
|
|
|
HbConnection.MedTrRes - Mediator function
|
Syntax:
|
MedTrRes() -> nResult
|
|
Parameters:
|
|
|
Return value:
|
nResult - Number
|
|
Top
|
|
|
HbConnection.MedTrRollb - Mediator function
|
Syntax:
|
MedTrRollb() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.MySQLDbTyp - Mediator function
|
Syntax:
|
MySQLDbTyp([<nNewTabType>]) -> nPreviousTabType
|
|
Parameters:
|
nNewTabType | - Number, in, optional |
|
|
Return value:
|
nPreviousTabType - Number
|
|
Top
|
|
|
HbConnection.MySQLMaxRc - Mediator function
|
Syntax:
|
MySQLMaxRc([<nMaxHeapRecords>]) -> nPreviousMax
|
|
Parameters:
|
nMaxHeapRecords | - Number, in, optional |
|
|
Return value:
|
nPreviousMax - Number
|
|
Top
|
|
|
HbConnection.OraDefTbsp - Mediator function
|
Syntax:
|
OraDefTbsp([<cUserName>]) -> cOracleDefaultTablespace
|
|
Parameters:
|
cUserName | - Character, in, optional |
|
|
Return value:
|
cOracleDefaultTablespace - Character
|
|
Top
|
|
|
HbConnection.OraStDflt - Mediator function
|
Syntax:
|
OraStDflt() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStEIntl - Mediator function
|
Syntax:
|
OraStEIntl(<nInitialExtent>) -> NIL
|
|
Parameters:
|
nInitialExtent | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStEMax - Mediator function
|
Syntax:
|
OraStEMax(<nMaxExtents>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStEMin - Mediator function
|
Syntax:
|
OraStEMin(<nMinExtents>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStENext - Mediator function
|
Syntax:
|
OraStENext(<nNextExtent>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStPctFr - Mediator function
|
Syntax:
|
OraStPctFr(<nPercentageFree>) -> NIL
|
|
Parameters:
|
nPercentageFree | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStPctIc - Mediator function
|
Syntax:
|
OraStPctIc(<nPercentageIncrease>) -> NIL
|
|
Parameters:
|
nPercentageIncrease | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStPctUd - Mediator function
|
Syntax:
|
OraStPctUd(<nPercentageUsed>) -> NIL
|
|
Parameters:
|
nPercentageUsed | - Number, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbConnection.OraStTbsp - Mediator function
|
Syntax:
|
OraStTbsp(<cTablespaceName>) -> NIL
|
|
Parameters:
|
cTablespaceName | - Character, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
3.3 HbTable object
3.3.1 xHarbour functions
HbTable.Bof - xHarbour function
|
Syntax:
|
Bof() -> lBofCondition
|
|
Parameters:
|
|
|
Return value:
|
lBofCondition - Logical
|
|
Top
|
|
|
HbTable.DbAppend - xHarbour function
|
Syntax:
|
DbAppend([<lReleaseRecLocks>]) -> NIL
|
|
Parameters:
|
lReleaseRecLocks | - Logical, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbClearFilter - xHarbour function
|
Syntax:
|
DbClearFilter() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbClearIndex - xHarbour function
|
Syntax:
|
DbClearIndex() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbClearRelation - xHarbour function
|
Syntax:
|
DbClearRelation() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbCloseArea - xHarbour function
|
Syntax:
|
DbCloseArea() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbCommit - xHarbour function
|
Syntax:
|
DbCommit() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbCommitAll - xHarbour function
|
Syntax:
|
DbCommitAll() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbCreate - xHarbour function
|
Syntax:
|
DbCreate(<cTabName>, <aStruct>, [<cDriver>], [<cCodePageID>]) -> lOpen
|
|
Parameters:
|
cTabName | - Character, in |
aStruct | - Variant, array, in |
cDriver | - Character, in, optional |
cCodePageID | - Character, in, optional |
|
|
Return value:
|
lOpen - Logical
|
|
Top
|
|
|
HbTable.DbCreateIndex - xHarbour function
|
Syntax:
|
DbCreateIndex(<cIndexName>, <cKeyExpr>, [<lUnique>]) -> NIL
|
|
Parameters:
|
cIndexName | - Character, in |
cKeyExpr | - Character, in |
lUnique | - Logical, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbDelete - xHarbour function
|
Syntax:
|
DbDelete() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbEval - xHarbour function
|
Syntax:
|
DbEval(<bBlock>, <bForCondition>, <bWhileCondition>, <nNextRecords>, <nRecord>, <lRest>) -> NIL
|
|
Parameters:
|
bBlock | - Block (string), in |
bForCondition | - Block (string), in |
bWhileCondition | - Block (string), in |
nNextRecords | - Number, in |
nRecord | - Number, in |
lRest | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbFieldInfo - xHarbour function
|
Syntax:
|
DbFieldInfo(<nInfoType>, <nFieldPos>) -> uCurrentSetting
|
|
Parameters:
|
nInfoType | - Number, in |
nFieldPos | - Number, in |
|
|
Return value:
|
uCurrentSetting - Variant
|
|
Top
|
|
|
HbTable.DbFilter - xHarbour function
|
Syntax:
|
DbFilter() -> cFilter
|
|
Parameters:
|
|
|
Return value:
|
cFilter - Character
|
|
Top
|
|
|
HbTable.DbGoBottom - xHarbour function
|
Syntax:
|
DbGoBottom() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbGoTo - xHarbour function
|
Syntax:
|
DbGoTo(<nRecord>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbGoTop - xHarbour function
|
Syntax:
|
DbGoTop() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbInfo - xHarbour function
|
Syntax:
|
DbInfo(<nInfoType>) -> uCurrentSetting
|
|
Parameters:
|
|
|
Return value:
|
uCurrentSetting - Variant
|
|
Top
|
|
|
HbTable.DbOrderInfo - xHarbour function
|
Syntax:
|
DbOrderInfo(<nInfoType>, [<cIndexFile>], [<cnOrderOrPos>], [<expNewSetting>]) -> uCurrentSetting
|
|
Parameters:
|
nInfoType | - Number, in |
cIndexFile | - Character, in, optional |
cnOrderOrPos | - Character, in, optional |
expNewSetting | - Variant, in, optional |
|
|
Return value:
|
uCurrentSetting - Variant
|
|
Top
|
|
|
HbTable.DbPack - xHarbour function
|
Syntax:
|
DbPack() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbRecall - xHarbour function
|
Syntax:
|
DbRecall() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbRecordInfo - xHarbour function
|
Syntax:
|
DbRecordInfo(<nInfoType>, [<nRecord>], [<expNewSetting>]) -> uCurrentSetting
|
|
Parameters:
|
nInfoType | - Number, in |
nRecord | - Number, in, optional |
expNewSetting | - Variant, in, optional |
|
|
Return value:
|
uCurrentSetting - Variant
|
|
Top
|
|
|
HbTable.DbReindex - xHarbour function
|
Syntax:
|
DbReindex() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbRelation - xHarbour function
|
Syntax:
|
DbRelation(<nRelation>) -> cLinkExp
|
|
Parameters:
|
|
|
Return value:
|
cLinkExp - Character
|
|
Top
|
|
|
HbTable.DbRlock - xHarbour function
|
Syntax:
|
DbRlock([<nRecord>]) -> lSuccess
|
|
Parameters:
|
nRecord | - Number, in, optional |
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.DbRlockList - xHarbour function
|
Syntax:
|
DbRlockList() -> aRecordLocks
|
|
Parameters:
|
|
|
Return value:
|
aRecordLocks - Variant, array
|
|
Top
|
|
|
HbTable.DbRSelect - xHarbour function
|
Syntax:
|
DbRSelect(<nRelation>) -> nWorkArea
|
|
Parameters:
|
|
|
Return value:
|
nWorkArea - Number
|
|
Top
|
|
|
HbTable.DbRUnlock - xHarbour function
|
Syntax:
|
DbRUnlock([<nRecord>]) -> NIL
|
|
Parameters:
|
nRecord | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbSeek - xHarbour function
|
Syntax:
|
DbSeek(<expKey>, [<lSoftSeek>], [<lLast>]) -> lFound
|
|
Parameters:
|
expKey | - Variant, in |
lSoftSeek | - Logical, in, optional |
lLast | - Logical, in, optional |
|
|
Return value:
|
lFound - Logical
|
|
Top
|
|
|
HbTable.DbSetFilter - xHarbour function
|
Syntax:
|
DbSetFilter(<bCondition>, [<cCondition>]) -> NIL
|
|
Parameters:
|
bCondition | - Block (string), in |
cCondition | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbSetIndex - xHarbour function
|
Syntax:
|
DbSetIndex(<cOrderBagName>) -> NIL
|
|
Parameters:
|
cOrderBagName | - Character, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbSetOrder - xHarbour function
|
Syntax:
|
DbSetOrder(<nOrderNum>) -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbSetRelation - xHarbour function
|
Syntax:
|
DbSetRelation(<cnAliasOrArea>, <bCondition>, [<cCondition>]) -> NIL
|
|
Parameters:
|
cnAliasOrArea | - Variant, in |
bCondition | - Block (string), in |
cCondition | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbSkip - xHarbour function
|
Syntax:
|
DbSkip([<nRecords>]) -> NIL
|
|
Parameters:
|
nRecords | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbStruct - xHarbour function
|
Syntax:
|
DbStruct() -> aStruct
|
|
Parameters:
|
|
|
Return value:
|
aStruct - Variant, array
|
|
Top
|
|
|
HbTable.DbUnlock - xHarbour function
|
Syntax:
|
DbUnlock() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbUseArea - xHarbour function
|
Syntax:
|
DbUseArea(<cDriver>, <cTabName>, [<lShared>], [<lReadonly>], [<cCodePageID>]) -> NIL
|
|
Parameters:
|
cDriver | - Character, in |
cTabName | - Character, in |
lShared | - Logical, in, optional |
lReadonly | - Logical, in, optional |
cCodePageID | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbUseSqlArea - xHarbour function
|
Syntax:
|
DbUseSqlArea(<cTabName>, <cSqlQuery>, [<lScrollable>], [<lPermanent>], [<nPrecision>], [<lOverwrite>], [<lC1AsLogical>], [<lShared>], [<lReadonly>], [<cCodePageID>]) -> NIL
|
|
Parameters:
|
cTabName | - Character, in |
cSqlQuery | - Character, in |
lScrollable | - Logical, in, optional |
lPermanent | - Logical, in, optional |
nPrecision | - Number, in, optional |
lOverwrite | - Logical, in, optional |
lC1AsLogical | - Logical, in, optional |
lShared | - Logical, in, optional |
lReadonly | - Logical, in, optional |
cCodePageID | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.DbZap - xHarbour function
|
Syntax:
|
DbZap() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.Deleted - xHarbour function
|
Syntax:
|
Deleted() -> lDeleted
|
|
Parameters:
|
|
|
Return value:
|
lDeleted - Logical
|
|
Top
|
|
|
HbTable.Directory - xHarbour function
|
Syntax:
|
Directory(<cDirSpec>, [<cAttributes>]) -> aDirectory
|
|
Parameters:
|
cDirSpec | - Character, in |
cAttributes | - Character, in, optional |
|
|
Return value:
|
aDirectory - Variant, array
|
|
Top
|
|
|
HbTable.Eof - xHarbour function
|
Syntax:
|
Eof() -> lEofCondition
|
|
Parameters:
|
|
|
Return value:
|
lEofCondition - Logical
|
|
Top
|
|
|
HbTable.FCount - xHarbour function
|
Syntax:
|
FCount() -> nFields
|
|
Parameters:
|
|
|
Return value:
|
nFields - Number
|
|
Top
|
|
|
HbTable.FieldGet - xHarbour function
|
Syntax:
|
FieldGet(<nField>) -> uFieldValue
|
|
Parameters:
|
|
|
Return value:
|
uFieldValue - Variant
|
|
Top
|
|
|
HbTable.FieldName - xHarbour function
|
Syntax:
|
FieldName(<nPosition>) -> cFieldName
|
|
Parameters:
|
|
|
Return value:
|
cFieldName - Character
|
|
Top
|
|
|
HbTable.FieldPos - xHarbour function
|
Syntax:
|
FieldPos(<cFieldPos>) -> nFieldPos
|
|
Parameters:
|
cFieldPos | - Character, in |
|
|
Return value:
|
nFieldPos - Number
|
|
Top
|
|
|
HbTable.FieldPut - xHarbour function
|
Syntax:
|
FieldPut(<nField>, <expAssign>) -> NIL
|
|
Parameters:
|
nField | - Number, in |
expAssign | - Variant, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.Flock - xHarbour function
|
Syntax:
|
Flock() -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.Found - xHarbour function
|
Syntax:
|
Found() -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.IndexExt - xHarbour function
|
Syntax:
|
IndexExt() -> cExtention
|
|
Parameters:
|
|
|
Return value:
|
cExtention - Character
|
|
Top
|
|
|
HbTable.IndexKey - xHarbour function
|
Syntax:
|
IndexKey(<nOrder>) -> cKeyExp
|
|
Parameters:
|
|
|
Return value:
|
cKeyExp - Character
|
|
Top
|
|
|
HbTable.IndexOrd - xHarbour function
|
Syntax:
|
IndexOrd() -> nOrder
|
|
Parameters:
|
|
|
Return value:
|
nOrder - Number
|
|
Top
|
|
|
HbTable.LastRec - xHarbour function
|
Syntax:
|
LastRec() -> nRecords
|
|
Parameters:
|
|
|
Return value:
|
nRecords - Number
|
|
Top
|
|
|
HbTable.LUpdate - xHarbour function
|
Syntax:
|
LUpdate() -> dModification
|
|
Parameters:
|
|
|
Return value:
|
dModification - Date
|
|
Top
|
|
|
HbTable.NetErr - xHarbour function
|
Syntax:
|
NetErr() -> lError
|
|
Parameters:
|
|
|
Return value:
|
lError - Logical
|
|
Top
|
|
|
HbTable.OrdBagExt - xHarbour function
|
Syntax:
|
OrdBagExt() -> cBagExt
|
|
Parameters:
|
|
|
Return value:
|
cBagExt - Character
|
|
Top
|
|
|
HbTable.OrdBagName - xHarbour function
|
Syntax:
|
OrdBagName([<cnOrderNameOrPos>]) -> cOrderBagName
|
|
Parameters:
|
cnOrderNameOrPos | - Number, in, optional |
|
|
Return value:
|
cOrderBagName - Character
|
|
Top
|
|
|
HbTable.OrdCondSet - xHarbour function
|
Syntax:
|
OrdCondSet([<cForCondition>], [<bForCondition>], [<lAll>], [<bWhileCondition>], [<bEval>], [<nInterval>], [<nStart>], [<nNext>], [<nRecord>], [<lRest>], [<lDescend>], [<cNil>], [<lAdditive>], [<lCurrent>], [<lCustom>], [<lNoOptimize>], [<cWhileCondition>]) -> lSuccess
|
|
Parameters:
|
cForCondition | - Character, in, optional |
bForCondition | - Block (string), in, optional |
lAll | - Logical, in, optional |
bWhileCondition | - Block (string), in, optional |
bEval | - Block (string), in, optional |
nInterval | - Number, in, optional |
nStart | - Number, in, optional |
nNext | - Number, in, optional |
nRecord | - Number, in, optional |
lRest | - Logical, in, optional |
lDescend | - Logical, in, optional |
cNil | - Character, in, optional |
lAdditive | - Logical, in, optional |
lCurrent | - Logical, in, optional |
lCustom | - Logical, in, optional |
lNoOptimize | - Logical, in, optional |
cWhileCondition | - Character, in, optional |
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.OrdCreate - xHarbour function
|
Syntax:
|
OrdCreate(<cOrderBagName>, [<cOrderName>], <cExpKey>, [<lUnique>]) -> NIL
|
|
Parameters:
|
cOrderBagName | - Character, in |
cOrderName | - Character, in, optional |
cExpKey | - Character, in |
lUnique | - Logical, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.OrdDescend - xHarbour function
|
Syntax:
|
OrdDescend([<cnOrderNameOrPos>], [<cIndexFile>], [<lNewDescend>]) -> lCurrentDescend
|
|
Parameters:
|
cnOrderNameOrPos | - Variant, in, optional |
cIndexFile | - Character, in, optional |
lNewDescend | - Logical, in, optional |
|
|
Return value:
|
lCurrentDescend - Logical
|
|
Top
|
|
|
HbTable.OrdDestroy - xHarbour function
|
Syntax:
|
OrdDestroy(<cOrderName>, <cOrderBagName>) -> NIL
|
|
Parameters:
|
cOrderName | - Character, in |
cOrderBagName | - Character, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.OrdIsUnique - xHarbour function
|
Syntax:
|
OrdIsUnique([<cnOrdNameOrPos>], [<cBagName>]) -> lUnique
|
|
Parameters:
|
cnOrdNameOrPos | - Variant, in, optional |
cBagName | - Character, in, optional |
|
|
Return value:
|
lUnique - Logical
|
|
Top
|
|
|
HbTable.OrdKey - xHarbour function
|
Syntax:
|
OrdKey([<cnOrderNameOrNum>], [<cOrderBagName>]) -> cExpKey
|
|
Parameters:
|
cnOrderNameOrNum | - Variant, in, optional |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
cExpKey - Character
|
|
Top
|
|
|
HbTable.OrdKeyCount - xHarbour function
|
Syntax:
|
OrdKeyCount([<cnOrderNameOrNum>], [<cOrderBagName>]) -> nKeys
|
|
Parameters:
|
cnOrderNameOrNum | - Variant, in, optional |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
nKeys - Number
|
|
Top
|
|
|
HbTable.OrdKeyGoTo - xHarbour function
|
Syntax:
|
OrdKeyGoTo(<nKeyNo>) -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.OrdKeyNo - xHarbour function
|
Syntax:
|
OrdKeyNo([<cnOrderNameOrNum>], [<cOrderBagName>]) -> nKeyNo
|
|
Parameters:
|
cnOrderNameOrNum | - Variant, in, optional |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
nKeyNo - Number
|
|
Top
|
|
|
HbTable.OrdKeyVal - xHarbour function
|
Syntax:
|
OrdKeyVal() -> uKeyValue
|
|
Parameters:
|
|
|
Return value:
|
uKeyValue - Variant
|
|
Top
|
|
|
HbTable.OrdListAdd - xHarbour function
|
Syntax:
|
OrdListAdd(<cOrderBagName>, [<cOrderName>]) -> NIL
|
|
Parameters:
|
cOrderBagName | - Character, in |
cOrderName | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.OrdListClear - xHarbour function
|
Syntax:
|
OrdListClear() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.OrdListRebuild - xHarbour function
|
Syntax:
|
OrdListRebuild() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.OrdName - xHarbour function
|
Syntax:
|
OrdName(<nOrder>, [<cOrderBagName>]) -> cOrderName
|
|
Parameters:
|
nOrder | - Number, in |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
cOrderName - Character
|
|
Top
|
|
|
HbTable.OrdNumber - xHarbour function
|
Syntax:
|
OrdNumber(<cOrderName>, [<cOrderBagName>]) -> nOrderNo
|
|
Parameters:
|
cOrderName | - Character, in |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
nOrderNo - Number
|
|
Top
|
|
|
HbTable.OrdScope - xHarbour function
|
Syntax:
|
OrdScope(<nScope>, [<expNewValue>]) -> uCurrentValue
|
|
Parameters:
|
nScope | - Number, in |
expNewValue | - Variant, in, optional |
|
|
Return value:
|
uCurrentValue - Variant
|
|
Top
|
|
|
HbTable.OrdSetFocus - xHarbour function
|
Syntax:
|
OrdSetFocus([<cnOrderNameOrNum>], [<cOrderBagName>]) -> cPrevOrderNameInFocus
|
|
Parameters:
|
cnOrderNameOrNum | - Variant, in, optional |
cOrderBagName | - Character, in, optional |
|
|
Return value:
|
cPrevOrderNameInFocus - Character
|
|
Top
|
|
|
HbTable.OrdSkipUnique - xHarbour function
|
Syntax:
|
OrdSkipUnique([<nDirection>]) -> lSuccess
|
|
Parameters:
|
nDirection | - Number, in, optional |
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.RddName - xHarbour function
|
Syntax:
|
RddName() -> cRDDName
|
|
Parameters:
|
|
|
Return value:
|
cRDDName - Character
|
|
Top
|
|
|
HbTable.RecCount - xHarbour function
|
Syntax:
|
RecCount() -> nRecords
|
|
Parameters:
|
|
|
Return value:
|
nRecords - Number
|
|
Top
|
|
|
HbTable.RecNo - xHarbour function
|
Syntax:
|
RecNo() -> nRecord
|
|
Parameters:
|
|
|
Return value:
|
nRecord - Number
|
|
Top
|
|
|
HbTable.RecSize - xHarbour function
|
Syntax:
|
RecSize() -> nBytes
|
|
Parameters:
|
|
|
Return value:
|
nBytes - Number
|
|
Top
|
|
|
HbTable.Rlock - xHarbour function
|
Syntax:
|
Rlock() -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.Select - xHarbour function
|
Syntax:
|
Select() -> nWorkArea
|
|
Parameters:
|
|
|
Return value:
|
nWorkArea - Number
|
|
Top
|
|
|
3.3.2 Mediator functions
HbTable.MedClrScpe - Mediator function
|
Syntax:
|
MedClrScpe([<nScope>]) -> NIL
|
|
Parameters:
|
nScope | - Number, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedDropIdx - Mediator function
|
Syntax:
|
MedDropIdx(<cIndex>, [<cBagName>]) -> NIL
|
|
Parameters:
|
cIndex | - Character, in |
cBagName | - Character, in, optional |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedFlocked - Mediator function
|
Syntax:
|
MedFlocked() -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbTable.MedGetLLst - Mediator function
|
Syntax:
|
MedGetLLst() -> aLockArray
|
|
Parameters:
|
|
|
Return value:
|
aLockArray - Variant, array
|
|
Top
|
|
|
HbTable.MedIdxDesc - Mediator function
|
Syntax:
|
MedIdxDesc([<nOrderNumber>]) -> lIndexDescending
|
|
Parameters:
|
nOrderNumber | - Number, in, optional |
|
|
Return value:
|
lIndexDescending - Logical
|
|
Top
|
|
|
HbTable.MedIdxKey - Mediator function
|
Syntax:
|
MedIdxKey(<cTableName>, <cIndex>, [<cOrderBag>]) -> cIndexKey
|
|
Parameters:
|
cTableName | - Character, in |
cIndex | - Character, in |
cOrderBag | - Character, in, optional |
|
|
Return value:
|
cIndexKey - Character
|
|
Top
|
|
|
HbTable.MedIdxUniq - Mediator function
|
Syntax:
|
MedIdxUniq([<nOrderNumber>]) -> lIndexUnique
|
|
Parameters:
|
nOrderNumber | - Number, in, optional |
|
|
Return value:
|
lIndexUnique - Logical
|
|
Top
|
|
|
HbTable.MedIgnDbN - Mediator function
|
Syntax:
|
MedIgnDbN(<lIgnoreDatabaseName>) -> NIL
|
|
Parameters:
|
lIgnoreDatabaseName | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedIgnPath - Mediator function
|
Syntax:
|
MedIgnPath(<lIgnorePath>) -> NIL
|
|
Parameters:
|
lIgnorePath | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedIsBag - Mediator function
|
Syntax:
|
MedIsBag(<cBagName>) -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbTable.MedIsFltr - Mediator function
|
Syntax:
|
MedIsFltr() -> lFilterInUse
|
|
Parameters:
|
|
|
Return value:
|
lFilterInUse - Logical
|
|
Top
|
|
|
HbTable.MedIsIdx - Mediator function
|
Syntax:
|
MedIsIdx(<cIndex>) -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbTable.MedKeyGoto - Mediator function
|
Syntax:
|
MedKeyGoto(<nLogicalPos>) -> lSuccess
|
|
Parameters:
|
|
|
Return value:
|
lSuccess - Logical
|
|
Top
|
|
|
HbTable.MedLMRecc - Mediator function
|
Syntax:
|
MedLMRecc(<lReccountMode>) -> NIL
|
|
Parameters:
|
lReccountMode | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedLMTGlob - Mediator function
|
Syntax:
|
MedLMTGlob() -> lTableGlobal
|
|
Parameters:
|
|
|
Return value:
|
lTableGlobal - Logical
|
|
Top
|
|
|
HbTable.MedPerfMod - Mediator function
|
Syntax:
|
MedPerfMod() -> lTableMode
|
|
Parameters:
|
|
|
Return value:
|
lTableMode - Logical
|
|
Top
|
|
|
HbTable.MedPerfRC - Mediator function
|
Syntax:
|
MedPerfRC() -> nReccount
|
|
Parameters:
|
|
|
Return value:
|
nReccount - Number
|
|
Top
|
|
|
HbTable.MedRfsRecc - Mediator function
|
Syntax:
|
MedRfsRecc() -> NIL
|
|
Parameters:
|
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedRfsRecT - Mediator function
|
Syntax:
|
MedRfsRecT([<nRefreshFlags>]) -> nPreviousFlags
|
|
Parameters:
|
nRefreshFlags | - Number, in, optional |
|
|
Return value:
|
nPreviousFlags - Number
|
|
Top
|
|
|
HbTable.MedSetOFil - Mediator function
|
Syntax:
|
MedSetOFil(<cSQLFilterCondition>) -> NIL
|
|
Parameters:
|
cSQLFilterCondition | - Character, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedSetQry - Mediator function
|
Syntax:
|
MedSetQry(<cSQLQuery>, <nPrecision>, <lScrollable>, <lPermanent>, <lOverwrite>, <lC1AsLogical>) -> NIL
|
|
Parameters:
|
cSQLQuery | - Character, in |
nPrecision | - Number, in |
lScrollable | - Logical, in |
lPermanent | - Logical, in |
lOverwrite | - Logical, in |
lC1AsLogical | - Logical, in |
|
|
Return value:
|
no return value
|
|
Top
|
|
|
HbTable.MedSetScpe - Mediator function
|
Syntax:
|
MedSetScpe(<nScope>, [<xValue>]) -> uCurrentValue
|
|
Parameters:
|
nScope | - Number, in |
xValue | - Variant, in, optional |
|
|
Return value:
|
uCurrentValue - Variant
|
|
Top
|
|
|
HbTable.MedShared - Mediator function
|
Syntax:
|
MedShared() -> lResult
|
|
Parameters:
|
|
|
Return value:
|
lResult - Logical
|
|
Top
|
|
|
HbTable.MedSrvFltr - Mediator function
|
Syntax:
|
MedSrvFltr() -> lFilterOnServer
|
|
Parameters:
|
|
|
Return value:
|
lFilterOnServer - Logical
|
|
Top
|
|
|
HbTable.MedTabOwnr - Mediator function
|
Syntax:
|
MedTabOwnr() -> cTableOwner
|
|
Parameters:
|
|
|
Return value:
|
cTableOwner - Character
|
|
Top
|
|
|
HbTable.MedTName - Mediator function
|
Syntax:
|
MedTName() -> cTableName
|
|
Parameters:
|
|
|
Return value:
|
cTableName - Character
|
|
Top
|
|
|
|