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:
01336295
Vues:
12
>SET DELETED ON
>
>txtPathName = "DADOS\ECT\" + "ECT" + CHRTRAN(DTOC(DATE()),"/","") + ".TXT"
>= MESSAGEBOX (txtPathName)
>SET SAFETY OFF
>COPY FILE (anxFullPth) TO (txtPathName)
>SELECT pgreembolso3
>DELETE ALL
>append FROM (txtPathName) type SDF && till here records are appended OK
>set safe on
>SELECT pgreembolso3
>
>Now I need to delete the first record , because its the header
>
>BROW
>GOTO 1
>DELETE
> PACK
>BROW ---- first record still there

NO WAY!
After PACK all deleted records should disappear.
SET DELETED ON

txtPathName =  "DADOS\ECT\" + "ECT" + CHRTRAN(DTOC(DATE()),"/","") + ".TXT"
= MESSAGEBOX (txtPathName)
SET SAFETY OFF
COPY FILE (anxFullPth) TO (txtPathName)
SELECT * FROM pgreembolso WHERE .f. INTO CURSOR pgreembolso3 READWRITE

SELECT pgreembolso3
append FROM (txtPathName)  type SDF  && till here records are appended OK
SELECT pgreembolso3
BROW
GOTO 1
DELETE
PACK
GO TOP
BROW 
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform