Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it possible to get the delete mark to transfer?
Message
De
17/12/2004 16:30:04
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00969860
Message ID:
00970190
Vues:
14
Thank you. Your example helped me to see what was happening in the cursors.

>Try this:
>
>SET DELETED OFF
>CREATE CURSOR tte (c1 C(2))
>FOR asd = 1 TO 20
>    INSERT INTO tte VALUES ("2")
>    IF asd%2 = 0
>       DELETE
>    ENDIF
>NEXT
>
>SELECT *, DELETED() AS IsDel FROM tte INTO CURSOR cTest
>BROW
>
>
>
>>I have a SQL statement that filters into a cursor.
>>The cursor brings in all of the records (as desired) but, it doesn't carry over the delete marks from the original table.
>>Is there a way to bring the delete marks over, while using SQL SELECT?
>>
>>Thanks in advance!
Thanks,

Chad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform