Problem inserting image
От | Tk421 |
---|---|
Тема | Problem inserting image |
Дата | |
Msg-id | 494FF3B4.9000201@gmail.com обсуждение исходный текст |
Ответы |
Re: Problem inserting image
|
Список | pgsql-sql |
I've made a routine in VB to insert a image into a table. The code is:<br /><br /> <small>Set cmd = New ADODB.Command<br/> cmd.ActiveConnection = objconexion<br /> cmd.CommandText = "INSERT INTO tb_tmp_ventanas(ventana) VALUES (?)"<br /> archivo = "c:\image.jpg"<br /> fd = FreeFile<br /> Open archivo For Binary Access Read As fd<br /> flen = LOF(fd)<br /> Set imagen = cmd.CreateParameter("imagen",adLongVarBinary, adParamInput, flen)<br /> ReDim chunk(1 To flen)<br /> Get fd, , chunk()<br /> imagen.AppendChunk chunk()<br /> cmd.Parameters.Append imagen<br/> Set rsInsert = cmd.Execute<br /> Close</small><br /> <br /><br /> But on executethere is the next error: ERROR: type "lo" does not exist;<br /><br /> How can i reference the "lo" type or createit, in postgres 8.3<br /><br /> Thank you very much<br />
В списке pgsql-sql по дате отправления: