September 27th, 2012, 05:14 AM
|
|
Registered User
|
|
Join Date: Sep 2012
Location: Croatia
Posts: 1
Time spent in forums: 14 m 42 sec
Reputation Power: 0
|
|
|
Saving images (byteA) to PG database with odbc on windows
Hello,
For some time i uses postgreSQL databases through VB.NET/odbc and I'm very satisfied with that.
But till today I was never successfully save a picture to byteA field of my database.
Most examples I found on net have some INSERT advices but I can't find an UPDATE (for replace pictures) example.
In short, this is how I try, unsuccessfully:
Code:
Using pgCommand As OdbcCommand = New OdbcCommand("UPDATE " & Tablename & " SET(?,?) WHERE record=" + RecNum, pgConnection)
pgCommand.Parameters.AddWithValue("@RecPicture", pgByteA)
Please any advice how to do that properly.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
