| Subject | RE: [firebird-support] Command to duplicate a record in a table |
|---|---|
| Author | Mercea Paul |
| Post date | 2009-08-27T06:27:41Z |
ex:
FOR SELECT new_key, field1, field2
FROM table
WHERE key = old_key
[PM] INTO :v_KEY, :v_field1, :v_field2...
DO
[PM] BEGIN
INSERT INTO table (:v_KEY, :v_field1, :v_field2...
Any suggestion?
Regards,
Paul
FOR SELECT new_key, field1, field2
FROM table
WHERE key = old_key
[PM] INTO :v_KEY, :v_field1, :v_field2...
DO
[PM] BEGIN
INSERT INTO table (:v_KEY, :v_field1, :v_field2...
Any suggestion?
Regards,
Paul