Function.ODBC.ConnectionName!RecordsetName.SaveBLOBToFile

From GAB Help
Jump to: navigation, search

This function saves the value of a Binary Long OBject (BLOB) database field into the specified fully-qualified filename. This command can be used with any database supporting this data type (MySQL, SQL Server, Pervasive SQL, Oracle, DB2, etc.). In Pervasive, the data type is LongVarBinary.

Syntax

Function.ODBC.ConnectionName!RecordsetName.SaveBLOBtoFile(field name, FQ filename)

Arguments

Field Name

Field name as string

File Name

Fully qualified file name as string

Example

Function.ODBC.ConnectionName!RecordsetName.SaveBLOBtoFile("PART","c:/")

Remarks

  • When using Pervasive SQL, this function is supported on 9.x versions, but is recommended only for 10.x and higher.