>Greetings to all.
>I have made a form which is bound to an "Appointments" table.Now when I want to delete a record from the "Appointmentss" table I have made a provision that the deleted record is backed up in a "BackUp2" table.The code in the Click event is as follows:
>
>SET DELETED OFF
> IF USED("Backup2")
> SELECT Backup2
> ELSE
> SELECT 0
> USE Backup2 AGAIN ALIAS Backup2
> ENDIF
>
>SELECT * FROM Appointments WHERE DELETED() = .T. ; INTO CURSOR Temp NOFILTER
> SELECT Temp
> lcDbf = DBF()
> SELECT Backup2
> APPEND FROM (lcDbf)
> SELECT Temp
> USE
> SELECT APPOINTMENTS
>
>The deleted record is copied to the 'BackUp2" table.
>What I need now is that a messagebox() to show if there has been a SINGLE , MULTIPLE or NO record(s) copied to the "BackUp2" table from the "Appointments" table.
>Thanks Again ye all.......
>Zaraq Bari
Are you sure you want to copy the entire contents of the appointments table every time a deletion is made? Why not just copy the record when it is deleted?
Erik Moore
Clientelligence