I've made a routine in VB to insert a image into a table. The code
is: Set cmd = New ADODB.Command cmd.ActiveConnection = objconexion cmd.CommandText = "INSERT INTO tb_tmp_ventanas (ventana) VALUES (?)" archivo = "c:\image.jpg" fd = FreeFile Open archivo For Binary Access Read As fd flen = LOF(fd) Set imagen = cmd.CreateParameter("imagen", adLongVarBinary, adParamInput, flen) ReDim chunk(1 To flen) Get fd, , chunk() imagen.AppendChunk chunk() cmd.Parameters.Append imagen Set rsInsert = cmd.Execute Close But on execute there is the next error: ERROR: type "lo" does not exist; How can i reference the "lo" type or create it, in postgres 8.3 Thank you very much |
- [SQL] Problem inserting image Tk421
- Re: [SQL] Problem inserting image Richard Broersma