Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Delete
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01336237
Message ID:
01336243
Vues:
11
>SELECT PGREEMBOLSO
> GOTO 1
> aa = RECNO()
> if ("ME") $ pgReembolso.valor
> DELETE FOR RECNO() = aa
>= MESSAGEBOX("deleted")
>brow
> endif
>
>the message box confirms deletion but in browse the record is still there

What is value of SET DELETED?
Also you ALWAYS will delete first record, no matter if it is deleted or not:
SELECT PGREEMBOLSO
GOTO 1
aa = RECNO() && That is always equal to 1
If you wan to check first non deleted record of tabl try this:
SELECT PGREEMBOLSO
SET DELETED ON
GO TOP
IF ("ME") $  pgReembolso.valor
   DELETE
   SKIP
    =MESSAGEBOX("deleted")
   brow
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform