Re: Image Insert Postgresql DB

On Tuesday 23 November 2004 01:49 pm, Premsun Choltanwanich wrote:
> I use VB as develop tool and ADO for connect. My code is show below and
> for vPicMember is stand ADOStream in Binary.
>
> rs.Open "SELECT * FROM t_mbrpic WHERE mbrsysid = " & vSysId, conn,
> adOpenStatic, adLockOptimistic
>     If rs.EOF Then rs.AddNew
>     rs!MbrSysId = vSysId
>     rs!MbrPic = vPicMember.Read
>     rs.Update
> rs.Close

i use python, and have no idea about ado, this might help:    
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-vblo

kg