>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
Hi Zaraq,
The _TALLY system variable will report the number of records selected into your cursor. Since this is the number that will be copied into your BackUp2 table, you can use this value to format your message.
hth,
George
Ubi caritas et amor, deus ibi est