> 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?
Well I don't know what your database is but in Oracle you can do the following
create table spam (id number, A char(20), b char(20));
insert into spam (1,'A','B');
insert into spam (A,B) select 'copy of "'||rtrim(A,' ')||'"',B from Spam where Id=:ID;
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz