At 08:32 AM 16/11/2004 +1300, you wrote:

>The exact same SQL as the source.
>
>It used to be
>srce.SQL.Text -> Select * from Tablename;
>Dest -> srce.SQL.text
>
>Now it is
>
>srce.SQL.Text -> Select FieldA, FieldB, FieldC from Tablename;
>Dest -> srce.SQL.text

Use a parameterised insert or update statement:
e.g.
insert into Tablename (<full list of required columns, matching src>)
values (:p1, :p2, .................>

or

update Tablename
set f1 = :p1,
....
where PK = :pk

Helen