does anyone know how to add a jpeg via sql
i tried something like

with MyDBISAMQuery do
  begin
   SQL.Clear;
   SQL.Add('UPDATE table Set imagefield=:MyJPEGField');
   SQL.Add('WHERE Recordno=:num')
   ParamByName('num').asinteger:=5
   ParamByName('MyJPEGField').LoadFromFile('myimage.jpg');
   ExecSQL;
  end;

but got a 'not enough parameters' Error.

Aaron,

<< but got a 'not enough parameters' Error. >>

It's probably this:

ParamByName('MyJPEGField').LoadFromFile('myimage.jpg',ftBlob);  <<< Add the
ftBlob parameter to the call

--
Tim Young
Elevate Software
www.elevatesoft.com