Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update - SQL
Message
De
18/05/1998 14:03:45
Carla Silva
Http - Produtos Informaticos, Lda.
Odivelas, Portugal
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Update - SQL
Divers
Thread ID:
00100150
Message ID:
00100150
Vues:
96
I`m using Scan........Endscan to print all records in a table marked for deleted.

select (vfich1)

Scan for deleted()
scatter memvar memo
report form licencas to printer prompt noconsole

if eof()
exit
endif
endscan

After the loop I`m i using the UPDATE - SQL to update all records marked for deleted in this table.

UPDATE (VFICH1) Set impressa=.t. Where impressa=.f. and Deleted()

The problem is that all records are eliminated and not updated

How can I`do to resolve this situaction ?


Thanks
Carla
Carla Silva
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform