can not save an image in postgres ...
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2009-05-26 03:29

hello, i have lazarus 0.9.7 (2009/05/20)
postgresql 8.2 in an linux server
i use zeosdbo

well i have to write an image i made this code (with some help of last
posts)

       Stream:= TMemoryStream.Create;
       imgFoto.Picture.Bitmap.SaveToStream(Stream); //i have an image
imgfoto (Timage)
        with DM.ZQryInsert do begin // a Zquery
           close;
           SQL.Add('insert into sttrabajador(trabNombre, trabApePa,
trabApeMa, trabdociden, trabimg)');
            SQL.Add('values (:nom, :apa, :ama, :doc, :imagen)');
            ParamByName('nom').AsString:=ediNombres.Text;
            ParamByName('apa').AsString:=ediPaterno.Text;
            ParamByName('ama').AsString:=ediMaterno.Text;
            ParamByName('doc').AsString:=ediDNI.Text;
            Params.ParamByName('imagen').DataType:=ftBlob;
            ParamByName('imagen').ParamType:=ptInput;
            ParamByName('imagen').LoadFromStream(Stream, ftBlob);
            Active:=true;
            Insert;
            Post;
         end;    

and error occur

SQL Error : invalid input syntax for the type OID
the trabimg field is an OID field.

some help please

----------------------------------------------------------------------
cpalx · 2009-05-26 04:42

i tried with bytea field, and same