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.
Function.ODBC.ConnectionName!RecordsetName.SaveBLOBtoFile(field name, FQ filename)
Field name as string
Fully qualified file name as string
- This function must be used with recordsets opened with either Function.ODBC.Connection!ConnectionName.OpenLocalRecordsetRW, or Function.ODBC.Connection!ConnectionName.OpenRecordsetRW
- When using Pervasive SQL, this function is supported on 9.x versions, but is recommended only for 10.x and higher.