VB + POSTGRESQL。怎样存储图片到数据库中,就像ORACLE的BLOB类型。
我使用ADODB.Stream,但总是报错。请大家帮帮忙。
代码如下: Dim rsTest As ADODB.RecordSet
Dim stmCon As New ADODB.Stream stmCon.LoadFromFile "C:\CHINA.JPG"
StrSql = "select * from c_world"
Call msDBOpenRecordSet(rsTest, StrSql, , adOpenDynamic, adLockOptimistic)
rsTest.AddNew
rsTest!admin_no = "00001"
rsTest!area = "ABC"
rsTest!area_password = "lkj4567"
rsTest!country = "中国"
rsTest!country_password = "a123B456"
rsTest.Fields("flag").Value = stmCon.Read
rsTest.Update
我使用ADODB.Stream,但总是报错。请大家帮帮忙。
代码如下: Dim rsTest As ADODB.RecordSet
Dim stmCon As New ADODB.Stream stmCon.LoadFromFile "C:\CHINA.JPG"
StrSql = "select * from c_world"
Call msDBOpenRecordSet(rsTest, StrSql, , adOpenDynamic, adLockOptimistic)
rsTest.AddNew
rsTest!admin_no = "00001"
rsTest!area = "ABC"
rsTest!area_password = "lkj4567"
rsTest!country = "中国"
rsTest!country_password = "a123B456"
rsTest.Fields("flag").Value = stmCon.Read
rsTest.Update
我使用AppendChunk方法也不行,为什么?再做不出来就只有走人了!!!!!