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
Teachers open the door, but you must enter by yourself.