如何访问关系型数据库中的图片

[perry_zh]

我现在有一dbf数据库，其中有一列存放图片，请问如何将该列中的图片读出，并放入notes一表单的rtf域，谢谢

[soup_man]

sql server里有image类型，跟其他类型一样，直接读到rtf里就可以了

[perry_zh]

那如何调用，例用odbc

[soup_man]

Uselsx "*LSXODBC"
Sub Initialize
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Dim firstName As String
Dim lastName As String
Dim msg As String
Set qry.Connection = con
Set result.Query = qry
con.ConnectTo("ATDB")
qry.SQL = "SELECT * FROM STUDENTS"
result.Execute
msg = "Student names:" & Chr(10)
If result.IsResultSetAvailable Then
Do
result.NextRow
firstName = result.GetValue("FIRSTNAME", _
firstName)
lastName = result.GetValue("LASTNAME", _
lastName)
msg = msg & Chr(10) & firstName & " " & _
lastName
Loop Until result.IsEndOfData
Messagebox msg,, "Student Names"
result.Close(DB_CLOSE)
Else
Messagebox "Cannot get result set for STUDENTS"
Exit Sub
End If
con.Disconnect
End Sub
与此类似吧，具体的找不到了，差不多的

[perry_zh]

这只能取到字符，但取不到图片

[perry_zh]

真的没人知道吗