Insert bytea type into PostgreSQL
| От | SUFFIAN RAMLI |
|---|---|
| Тема | Insert bytea type into PostgreSQL |
| Дата | |
| Msg-id | F46XfhCuIKe4YSeE1cH00008f13@hotmail.com обсуждение исходный текст |
| Список | pgsql-general |
Hi,
I'm having a problem right now getting error message "Operation is not
allowed in this context" when I'm trying to INSERT/UPDATE to Database.
I'm using Visual Basic (ADO).
This is the code :
Dim rs As ADODB.Recordset
Dim varImg As Variant
Dim varChunk As Variant
Dim lngImgSize As Long
Dim lngImgOffset As Long
If Len(objMsgFormat.sImageData) > 0 Then ' String
varImg = objMsgFormat.byteArrayImage ' Convert String to Byte
lngImgSize = LenB(varImg)
lngImgOffset = 0
Do While lngImgOffset < lngImgSize
varChunk = LeftB(RightB(varImg, lngImgSize - lngImgOffset), 100)
rs!Signature.AppendChunk varChunk ' This line cause the error
lngImgOffset = lngImgOffset + 100
Loop
End If
Can somebody assistance me to sovled this.
Rgds
Suffian Ramli
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
В списке pgsql-general по дате отправления: