DbServer Methods (Typed)

DbServer.Append Method

DbServer.AppendDB Method (Typed)

DbServer.AppendDelimited Method (Typed)

DbServer.AppendSDF Method (Typed)

DbServer.Average Method (Typed)

DbServer.BLOBDirectExport Method

DbServer.BLOBDirectGet Method (Typed)

DbServer.BLOBDirectImport Method

DbServer.BLOBDirectPut Method (Typed)

DbServer.BLOBExport Method

DbServer.BLOBGet Method (Typed)

DbServer.BLOBImport Method (Typed)

DbServer.BLOBRootGet Method (Typed)

DbServer.BLOBRootLock Method (Typed)

DbServer.BLOBRootPut Method (Typed)

DbServer.BLOBRootUnlock Method (Typed)

DbServer.ClearFilter Method (Typed)

DbServer.ClearIndex Method (Typed)

DbServer.ClearLocate Method (Typed)

DbServer.ClearOrderScope Method (Typed)

DbServer.ClearRelation Method (Typed)

DbServer.ClearScope Method (Typed)

DbServer.Close Method (Typed)

DbServer.Commit Method (Typed)

DbServer.ConstructUniqueAlias Method (Typed)

DbServer.Continue Method (Typed)

DbServer.CopyDB Method (Typed)

DbServer.CopyDelimited Method (Typed)

DbServer.CopySDF Method (Typed)

DbServer.CopyStructure Method

DbServer.Count Method (Typed)

DbServer.CreateIndex Method (Typed)

DbServer.CreateOrder Method (Typed)

DbServer.DataField Method (Typed)

DbServer.Delete Method

DbServer.DeleteAll Method (Typed)

DbServer.DeleteOrder Method (Typed)

DbServer.Error Method (Typed)

DbServer.Eval Method (Typed)

DbServer.FieldGet Method (Typed)

DbServer.FieldGetBytes Method (Typed)

DbServer.FieldGetFormatted Method (Typed)

DbServer.FieldHyperLabel Method (Typed)

DbServer.FieldInfo Method (Typed)

DbServer.FieldName Method (Typed)

DbServer.FieldPos Method (Typed)

DbServer.FieldPut Method (Typed)

DbServer.FieldPutBytes Method (Typed)

DbServer.FieldSpec Method (Typed)

DbServer.FieldStatus Method (Typed)

DbServer.FieldSym Method (Typed)

DbServer.FieldValidate Method (Typed)

DbServer.FLock Method (Typed)

DbServer.GetArray Method (Typed)

DbServer.GetLocate Method (Typed)

DbServer.GetLookupTable Method (Typed)

DbServer.GoBottom Method (Typed)

DbServer.GoTo Method (Typed)

DbServer.GoTop Method (Typed)

DbServer.IndexKey Method (Typed)

DbServer.IndexOrd Method (Typed)

DbServer.Info Method (Typed)

DbServer.Join Method (Typed)

DbServer.Locate Method (Typed)

DbServer.LockCurrentRecord Method (Typed)

DbServer.LockSelection Method (Typed)

DbServer.NoIVarGet Method (Typed)

DbServer.NoIVarPut Method (Typed)

DbServer.Notify Method (Typed)

DbServer.OrderDescend Method

DbServer.OrderInfo Method (Typed)

DbServer.OrderIsUnique Method

DbServer.OrderKeyAdd Method

DbServer.OrderKeyCount Method

DbServer.OrderKeyDel Method

DbServer.OrderKeyGoTo Method (Typed)

DbServer.OrderKeyNo Method

DbServer.OrderScope Method (Typed)

DbServer.OrderSkipUnique Method (Typed)

DbServer.Pack Method (Typed)

DbServer.RddInfo Method (Typed)

DbServer.Recall Method (Typed)

DbServer.RecallAll Method (Typed)

DbServer.RecordInfo Method (Typed)

DbServer.Refresh Method (Typed)

DbServer.Reindex Method (Typed)

DbServer.Relation Method (Typed)

DbServer.Replace Method (Typed)

DbServer.ResetNotification Method (Typed)

DbServer.RLock Method (Typed)

DbServer.RLockVerify Method (Typed)

DbServer.Seek Method

DbServer.Select Method (Typed)

DbServer.SetDataField Method (Typed)

DbServer.SetFilter Method (Typed)

DbServer.SetIndex Method

DbServer.SetOrder Method

DbServer.SetOrderCondition Method (Typed)

DbServer.SetRelation Method (Typed)

DbServer.SetSelectiveRelation Method (Typed)

DbServer.Skip Method (Typed)

DbServer.Sort Method

DbServer.Sum Method (Typed)

DbServer.SuspendNotification Method (Typed)

DbServer.Total Method (Typed)

DbServer.UnLock Method (Typed)

DbServer.Update Method

DbServer.Zap Method (Typed)

DbServer.BLOBDirectGet Method (Typed)

Retrieve data stored in a BLOB file without referencing a specific field.

Namespace: XSharp.VO.SDK
Assembly: XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.21

Syntax

Copy

 VIRTUAL METHOD BLOBDirectGet(
	nPointer AS LONG,
	nStart AS LONG,
	nCount AS LONG
) AS USUAL

public virtual Usual BLOBDirectGet(
	int nPointer,
	int nStart,
	int nCount
)

Request Example View Source

Parameters

nPointer: Type: Long
A pointer to the BLOB data. This pointer can be obtained using DBServer:BLOBDirectPut(), DBServer:BLOBDirectImport(), or DBServer:FieldInfo(DBS_BLOB_POINTER, nFieldPos).
nStart: Type: Long
The starting position in nPointer. If nStart is positive, the starting position is relative to the leftmost character in nPointer. If nStart is negative, it is relative to the rightmost character in nPointer. If nStart is omitted, it is assumed to be 1.
nCount: Type: Long
The number of bytes of data to retrieve, beginning at nStart. If nCount is larger than the amount of data stored, excess data is ignored. If omitted, DBServer:BLOBDirectGet() retrieves to the end of the data.

Return Value

Type: Usual
The data retrieved from the BLOB file. The data type of the return value depends on the actual data stored. Use ValType() or UsualType() to determine the data type.

Remarks

Tip
nStart and nCount apply to string data only. They are ignored for any other data types.

DBServer:BLOBDirectGet() retrieves data stored in a BLOB file without the need to reference a particular field in the data server. It is particularly useful when accessing data that is larger than 64KB, (such as memo fields created with the BLOBImport() method).

Examples

This example illustrates storing setup information in a BLOB file, then selectively retrieving the stored information:

Copy

 1FUNCTION PutSettings(aColors AS ARRAY,;
 2aPaths AS ARRAY, aPW AS ARRAY) AS VOID
 3LOCAL aSettings AS ARRAY
 4LOCAL oDBSetup AS DBServer
 5oDBSetup := Setup{}
 6aSettings := {}
 7AAdd(aSettings, oDBSetup:BLOBDirectPut(0, aColors))
 8AAdd(aSettings, oDBSetup:BLOBDirectPut(0, aPaths))
 9AAdd(aSettings, oDBSetup:BLOBDirectPut(0, aPW))
10oDBSetup:BLOBRootPut(aSettings)
11oDBSetup:Close()
12FUNCTION GetColors() AS ARRAY
13LOCAL aSettings AS ARRAY
14LOCAL aColors  AS ARRAY
15LOCAL oDBSetup AS DBServer
16oDBSetup := Setup{}
17aSettings := oDBSetup:BLOBRootGet()
18aColors := oDBSetup:BLOBDirectGet(aSettings[1])
19oDBSetup:Close()
20RETURN aColors

Reference

DbServer Class

XSharp.VO.SDK Namespace