Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Message Box Anguish
Message
From
04/08/1998 07:42:24
Zaraq Bari
Bari Studios Limited
Lahore, Pakistan
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Message Box Anguish
Miscellaneous
Thread ID:
00123740
Message ID:
00123740
Views:
60
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.
Next
Reply
Map
View

Click here to load this message in the networking platform