Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Message Box Anguish
Message
De
04/08/1998 07:42:24
Zaraq Bari
Bari Studios Limited
Lahore, Pakistan
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Message Box Anguish
Divers
Thread ID:
00123740
Message ID:
00123740
Vues:
61
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform