辦法肯定有。可以在Table中定義一個image字段,用來儲JPG數據。不知道你前端工具用什麼?假如是用VB+ADO的話,那就很方便的存取里面的資料。
像用Recordset.GetChunk或者用ADO.Stream對像都很方便。
EX:
Dim idx As Integer
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;data Source=NIPSAN;Initial Catalog=pubs;User Id=sa;Password=;"Set rs = New ADODB.Recordset
rs.Open "Select * from pub_info", cn, adOpenKeyset, adLockOptimisticSet mstream = New ADODB.Streammstream.Type = adTypeBinary
mstream.OpenFor idx = 1 To rs.RecordCount
mstream.Write rs.Fields("logo").Value
mstream.SaveToFile "c:\publogo" & idx & ".gif", adSaveCreateOverWrite
rs.MoveNext
Next idx
rs.Close
cn.Close
像用Recordset.GetChunk或者用ADO.Stream對像都很方便。
EX:
Dim idx As Integer
Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB;data Source=NIPSAN;Initial Catalog=pubs;User Id=sa;Password=;"Set rs = New ADODB.Recordset
rs.Open "Select * from pub_info", cn, adOpenKeyset, adLockOptimisticSet mstream = New ADODB.Streammstream.Type = adTypeBinary
mstream.OpenFor idx = 1 To rs.RecordCount
mstream.Write rs.Fields("logo").Value
mstream.SaveToFile "c:\publogo" & idx & ".gif", adSaveCreateOverWrite
rs.MoveNext
Next idx
rs.Close
cn.Close
我不太記得SQL的image字段可存多大了。2-3m肯定不是問題。不過速度肯定會打折。
怎么把图片数据存进去?
IF LEN(ALLT("file_name"))>0
APPEND GENERAL zp from "file_name link
ENDIF
THISFORM.REFRESH
字段用long raw或blob, 读入时用read_image_file, 显示的话用查询就行了
mstream.LoadFromFile "C:\Tigger.jpg"
rs.Fields("logo").Value = mstream.Read
能说的具体点吗?谢谢:)