Thread: helps required in postgresql and visual basic 6.0

helps required in postgresql and visual basic 6.0

From
"Vishnu Aggarwal"
Date:
hello sir<br /><br />I am software engineer. i have a problem in postgresql. i am using postgresql 8.2.4 version and i
havesave image in table by java program<br /> my table fields as id-integer ,image -bytea <br /><br />i insert image by
javain prepared statement by setbinarystream() its running perfects. <br />i can retrieve image by java application
also.<br /><br />but when i used this in visual basic 6.0 its gives problem <br /><br />               Dim Chunk() As
Byte<br/>               Open imagename For Binary Access Write As #1 <br />                   ReDim Chunk(1 To
RS("FImage").ActualSize)<br/>                   <br />                   Chunk() =
RS("FImage").GetChunk(RS("FImage").ActualSize)<br/>                   Put 1, , Chunk() <br />               Close #1<br
/><br/><br />its says when its comes in image field its gives  errors<br /><br />operation is not allowed in this
context<br/><br />helps me out <br /><br /><br />regards<br />vishnu aggarwal<br /><br /><br /><br /> 

Re: helps required in postgresql and visual basic 6.0

From
"Heikki Linnakangas"
Date:
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