Function.ODBC.ConnectionName!RecordsetName.SaveFileToBlob

From GAB Help
Jump to: navigation, search

This function saves the binary contents of the specified fully-qualified filename into a Binary Long OBject (BLOB) database field. 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.SaveFiletoBLOB(field name, FQ filename)

Arguments

Field Name

Field name as string

File Name

Fully qualified file name as string

Example

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

Remarks

  • This function must be used with recordsets opened with either Function.ODBC.Connection!Conname.OpenLocalRecordsetRW, or Function.ODBC.Connection!Conname.OpenRecordsetRW
  • When using Pervasive SQL, this function is supported on 9.x versions, but is recommended only for 10.x and higher.