Subject | Re: [IBO] IB_Pump |
---|---|
Author | Helen Borrie |
Post date | 2004-11-15T23:32:28Z |
At 08:32 AM 16/11/2004 +1300, you wrote:
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
>The exact same SQL as the source.Use a parameterised insert or update statement:
>
>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
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