RetrieveFileFromField

Syntax

SQL.RetrieveFileFromField ADOField, rtvFileName

Description

Translates binary data stored in a SQL-BLOB (Binary Large OBject) field to a file and stores it in rtvFileName.

Parameter	Description
ADOField	ADODB.Field object in which the binary data is stored.
rtvFileName	Full path and file name in which the data is stored. If the file already exists, it will be overwritten.

See Also

StoreFileInField, StoreImage.

Example

Sub Main()
 
    Dim rsRecord As ADODB.Recordset
    SQL.RunRecordset "SELECT * FROM Images", rsRecord
 
    Do While Not rsRecord.EOF
        SQL.RetrieveFileFromField rsRecord!Data, rsRecord!FileName
        SQL.DisplayStatus "Retrieved " & rsRecord!FileName
        rsRecord.MoveNext
    Loop
 
    rsRecord.Close
    Set rsRecord = Nothing
 
End Sub