Oops... the project syntax should have been..
PROJECT TEMPORARY tmpLigne FROM Ligne USING * WHERE numcde = .vnumcde_old
Rommel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Rommel Relosa
Sent: Wednesday, May 02, 2001 10:53 AM
To: [EMAIL PROTECTED]
Subject: RE: Q. about APPEND - Razzak's Reply
J.M.
You can try to project the row you want to duplicate to a temporary table
then re-insert it to the main table.
PROJECT tmpLigne FROM Ligne USING * WHERE numcde = .vnumcde_old
APPEND tmpLigne TO Ligne
The beauty of using a temporary table is that you can easily make data
changes to the temporary table (ie: constraints, rules, etc.) prior to
re-inserting the row back to the original table.
Rommel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of J.M. GRATIAS
Sent: Wednesday, May 02, 2001 3:37 AM
To: INTERNET:[EMAIL PROTECTED]
Subject: Re: Q. about APPEND - Razzak's Reply
Razzak :
>>
You CAN use the APPEND command.
You need to keep in mind the PKs and OTHER table constraints!
<<
No problem : numcde is a FK.
As original rows are corrects, duplicated rows should be also corrects.
To workaround the problem, I think I'll have more success with UNLOAD and
LOAD.
Any other idea ?
J.M. GRATIAS, Logimatique, France
>Is there any objection about using APPEND to add new
>rows to a table comming from the same table ?
>What I want to do is duplicate some rows ...
>APPEND ligne TO ligne WHERE (numcde = .vnumcde_old)
>From time to time, it make RBW 65+ to abort (page fault at adress ..... x
3 ) and return to W98.
