helps required in postgresql and visual basic 6.0

Started by Vishnu Aggarwalover 18 years ago2 messages
#1Vishnu Aggarwal
aggarwal.vishnu@gmail.com

hello sir

I am software engineer. i have a problem in postgresql. i am using
postgresql 8.2.4 version and i have save image in table by java program
my table fields as id-integer ,image -bytea

i insert image by java in prepared statement by setbinarystream() its
running perfects.
i can retrieve image by java application also.

but when i used this in visual basic 6.0 its gives problem

Dim Chunk() As Byte
Open imagename For Binary Access Write As #1
ReDim Chunk(1 To RS("FImage").ActualSize)

Chunk() = RS("FImage").GetChunk(RS("FImage").ActualSize)
Put 1, , Chunk()
Close #1

its says when its comes in image field its gives errors

operation is not allowed in this context

helps me out

regards
vishnu aggarwal

#2Heikki Linnakangas
heikki@enterprisedb.com
In reply to: Vishnu Aggarwal (#1)
Re: helps required in postgresql and visual basic 6.0

Vishnu Aggarwal wrote:

I am software engineer. i have a problem in postgresql. i am using
postgresql 8.2.4 version and i have save image in table by java program
my table fields as id-integer ,image -bytea

i insert image by java in prepared statement by setbinarystream() its
running perfects.
i can retrieve image by java application also.

but when i used this in visual basic 6.0 its gives problem

This mailing list is for discussions regarding development of PostgreSQL
server. Please post your question on a more appropriate list.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com