X# Runtime and VO SDK Reference
X# Runtime and SDK Reference
VO Namespace
DbServer Class
DbServer Methods
DbServer.Append Method
DbServer.AppendDB Method
DbServer.AppendDelimited Method
DbServer.AppendSDF Method
DbServer.Average Method
DbServer.BLOBDirectExport Method
DbServer.BLOBDirectGet Method
DbServer.BLOBDirectImport Method
DbServer.BLOBDirectPut Method
DbServer.BLOBExport Method
DbServer.BLOBGet Method
DbServer.BLOBImport Method
DbServer.BLOBRootGet Method
DbServer.BLOBRootLock Method
DbServer.BLOBRootPut Method
DbServer.BLOBRootUnlock Method
DbServer.ClearFilter Method
DbServer.ClearIndex Method
DbServer.ClearLocate Method
DbServer.ClearOrderScope Method
DbServer.ClearRelation Method
DbServer.ClearScope Method
DbServer.Close Method
DbServer.Commit Method
DbServer.ConstructUniqueAlias Method
DbServer.Continue Method
DbServer.CopyDB Method
DbServer.CopyDelimited Method
DbServer.CopySDF Method
DbServer.CopyStructure Method
DbServer.Count Method
DbServer.CreateIndex Method
DbServer.CreateOrder Method
DbServer.DataField Method
DbServer.Delete Method
DbServer.DeleteAll Method
DbServer.DeleteOrder Method
DbServer.Error Method
DbServer.Eval Method
DbServer.FIELDGET Method
DbServer.FieldGetBytes Method
DbServer.FieldGetFormatted Method
DbServer.FieldHyperLabel Method
DbServer.FieldInfo Method
DbServer.FieldName Method
DbServer.FieldPos Method
DbServer.FIELDPUT Method
DbServer.FieldPutBytes Method
DbServer.FieldSpec Method
DbServer.FieldStatus Method
DbServer.FieldSym Method
DbServer.FieldValidate Method
DbServer.FLOCK Method
DbServer.GetArray Method
DbServer.GetLocate Method
DbServer.GetLookupTable Method
DbServer.GoBottom Method
DbServer.GoTo Method
DbServer.GoTop Method
DbServer.INDEXKEY Method
DbServer.INDEXORD Method
DbServer.Info Method
DbServer.Join Method
DbServer.Locate Method
DbServer.LockCurrentRecord Method
DbServer.LockSelection Method
DbServer.NoIVarGet Method
DbServer.NoIVarPut Method
DbServer.Notify Method
DbServer.OrderDescend Method
DbServer.OrderInfo Method
DbServer.OrderIsUnique Method
DbServer.OrderKeyAdd Method
DbServer.OrderKeyCount Method
DbServer.OrderKeyDel Method
DbServer.OrderKeyGoTo Method
DbServer.OrderKeyNo Method
DbServer.OrderScope Method
DbServer.OrderSkipUnique Method
DbServer.Pack Method
DbServer.RDDINFO Method
DbServer.Recall Method
DbServer.RecallAll Method
DbServer.RecordInfo Method
DbServer.Refresh Method
DbServer.Reindex Method
DbServer.Relation Method
DbServer.Replace Method
DbServer.ResetNotification Method
DbServer.RLOCK Method
DbServer.RLockVerify Method
DbServer.Seek Method
DbServer.SELECT Method
DbServer.SetDataField Method
DbServer.SetFilter Method
DbServer.SetIndex Method
DbServer.SetOrder Method
DbServer.SetOrderCondition Method
DbServer.SetRelation Method
DbServer.SetSelectiveRelation Method
DbServer.Skip Method
DbServer.Sort Method
DbServer.Sum Method
DbServer.SuspendNotification Method
DbServer.Total Method
DbServer.UnLock Method
DbServer.Update Method
DbServer.Zap Method
Click or drag to resize

DbServer.BLOBImport Method

X#
Read the contents of a file as a BLOB, identified by a memo field number.

Namespace:  VO
Assembly:  VORDDClasses (in VORDDClasses.dll) Version: 2.21
Syntax
Copy
 VIRTUAL METHOD BLOBImport(
	uField,
	oFSSource
) AS USUAL CLIPPER
Request Example View Source

Parameters

uField (Optional)
Type: Usual
The name, number, or symbol representing the position of the field in the database file structure.
oFSSource (Optional)
Type: Usual
A string or filespec object that specifies the name of the file from which to read the BLOB data, including an optional drive, directory, and extension. See SetDefault() and SetPath() for file searching and creation rules. No default extension is assumed.

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.
Remarks
This method attempts to open the source file in shared mode. If the file does not exist, a runtime error is raised. If the file is successfully opened, the operation proceeds. If access is denied because, for example, another process has exclusive use of the file, NetErr() is set to TRUE and the data server's Status property is set. Refer to the 'Concurrency Control' chapter in the Programmer's Guide for more information on resolving concurrency conflicts.
Tip Tip
There are no restrictions on the size of the source file except that you must have enough disk space to make the copy.
DBServer:BLOBImport() provides a mechanism for copying the contents of a file into a memo field as BLOB data. DBServer:BLOBImport() is used in conjunction with DBServer:BLOBExport() to transfer BLOB data back and forth between files and memo fields. You can use DBServer:BLOBImport() with a variety of file types, including graphics images, word processor files, and printer fonts. These two methods are excellent for creating databases of documents, graphics, sounds, and so on. DBServer:BlobImport() sends a NotifyFieldChange message upon successful completion.
Tip Tip
DBServer:FieldInfo(DBS_BLOB_TYPE, uFieldPos) will return "C" (string) for any memo field created using DBServer:BLOBImport().
Examples
This example imports information from a word processing document into a field, then uses DBServer:BLOBGet() to extract the first 25 characters of the field:
X#
Copy
 1FUNCTION Populate()
 2LOCAL oDBCust AS DBServer
 3oDBCust := Customer{}
 4// Construct unique name based on last name     // and id
 5DO WHILE .NOT. oDBCust:EOF
 6oDBCust:GetPix("Pix", ;
 7Substr(oDBCust:LastName, 1, 4) + oDBCust:CustID)
 8oDBCust:Skip()
 9ENDDO
10METHOD GetPix(cPixField, cPixFile) CLASS Customer
11LOCAL nPos
12nPos := SELF:FieldPos(cPixField)
13// Import the picture file into indicated     // field
14IF !SELF:BLOBImport(nPos, cPixFile)
15Alert("Import of picture " + cPixFile + "     failed!")
16ENDIF
See Also