Board index » delphi » How to duplicate a record ib 6
Paul Elliott
Delphi Developer |
Paul Elliott
Delphi Developer |
How to duplicate a record ib 62003-08-06 10:27:02 PM delphi155 I would like to know if there is a fast way to duplicate a record Thank in advance Paul Elliott |
Craig Stuntz [TeamB]
Delphi Developer |
2003-08-07 12:14:03 AM
Re:How to duplicate a record ib 6
Paul Elliott writes:
QuoteI would like to know if there is a fast way to duplicate a record ID, FIELD1, FIELD2, ...) SELECT GEN_ID(FOO_G, 1) FIELD1, FIELD2, ... FROM FOO WHERE ID = /* Original record ID */ -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : delphi.weblogs.com InterBase PLANalyzer 1.1 -- Free InterBase query optimization tool: delphi.weblogs.com/IBPLANalyzer |
Paul Elliott
Delphi Developer |
2003-08-07 02:24:14 AM
Re:How to duplicate a record ib 6
Thanks Craig,
I mean a generic Duplication function I think this should be standard in database Thanks Paul Elliott "Craig Stuntz [TeamB]" <XXXX@XXXXX.COM>writes QuotePaul Elliott writes: |
Paul Linehan
Delphi Developer |
2003-08-07 05:45:30 PM
Re:How to duplicate a record ib 6
XXXX@XXXXX.COM says...
QuoteThanks Craig, QuotePaul Elliott C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 p.s. just lacerated a tendon in left hand, so pls excuse typos and tricky abbrevs - TIA. |