Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to get the delete mark to transfer?
Message
From
17/12/2004 16:30:04
 
 
To
16/12/2004 17:22:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969860
Message ID:
00970190
Views:
15
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
Previous
Reply
Map
View

Click here to load this message in the networking platform