I'm wanting to insert a record into a table via SQL that has a blob field,
at the moment I'm using this code:

    Query.Close;
    Query.SQL.Text := Format('INSERT INTO CTabHed ( Name, Landscape ) VALUES
( "Copy of ''%s''", False )',[
      dmSTEAMMAN.qCTabHed.FieldByName('Name').AsString]);
    Query.ExecSQL;

What I'm doing is duplicating a record, the table CTabHed has a binary blob
field called Layout which I also wish to duplicate, whats the easiest way of
doing this?

Mark


---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to