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