reporting on flagged records

[Barbara Peisch]

If you're not looking for any fancy formatting, you can just do this:

SET DELETED OFF
USE tablename
LIST OFF TO PRINT FOR DELETED()



-BP
www.peisch.com

FoxPro Info: http://msdn.microsoft.com/vfoxpro
FoxPro News: http://foxcentral.net


"rbryant" <rlbryant@triad.rr.com> wrote in message
news:3d1a7aaf@10.1.10.29...
>
> I am completely new to Visual FoxPro. I need to report on all the records
> in a given table that are flagged for deletion so the user can decide
whether
> they actually want to delete the flagged records. How would I go about
this?
> The Query Wizard (VFP6) allows me to build a query based on field values
> but not general record conditions like the deletion marker.
>
> Thank you
> RBryant

[rbryant]

I am completely new to Visual FoxPro. I need to report on all the records
in a given table that are flagged for deletion so the user can decide whether
they actually want to delete the flagged records. How would I go about this?
The Query Wizard (VFP6) allows me to build a query based on field values
but not general record conditions like the deletion marker.

Thank you
RBryant

[RBryant]

Thank you very much for the reply. I'm sorry to be so dense but if I type
the lines above into the Command Window how do I get it to run? Also, I need
to print it to disk and not to a printer. Thank you very much for your help!!

RBryant

"Barbara Peisch" <barbara@peisch.com> wrote:
>If you're not looking for any fancy formatting, you can just do this:
>
>SET DELETED OFF
>USE tablename
>LIST OFF TO PRINT FOR DELETED()
>
>
>
> -BP
> www.peisch.com
>
>FoxPro Info: http://msdn.microsoft.com/vfoxpro
>FoxPro News: http://foxcentral.net
>
>
>"rbryant" <rlbryant@triad.rr.com> wrote in message
>news:3d1a7aaf@10.1.10.29...
>>
>> I am completely new to Visual FoxPro. I need to report on all the records
>> in a given table that are flagged for deletion so the user can decide
>whether
>> they actually want to delete the flagged records. How would I go about
>this?
>> The Query Wizard (VFP6) allows me to build a query based on field values
>> but not general record conditions like the deletion marker.
>>
>> Thank you
>> RBryant
>
>

[RBryant]

Hi,

Please ignore my earlier reply. With the code you provided to me I was able
to figure out how to do what I needed.

Thank you so much for your help!!

RBryant

"Barbara Peisch" <barbara@peisch.com> wrote:
>If you're not looking for any fancy formatting, you can just do this:
>
>SET DELETED OFF
>USE tablename
>LIST OFF TO PRINT FOR DELETED()
>
>
>
> -BP
> www.peisch.com
>
>FoxPro Info: http://msdn.microsoft.com/vfoxpro
>FoxPro News: http://foxcentral.net
>
>
>"rbryant" <rlbryant@triad.rr.com> wrote in message
>news:3d1a7aaf@10.1.10.29...
>>
>> I am completely new to Visual FoxPro. I need to report on all the records
>> in a given table that are flagged for deletion so the user can decide
>whether
>> they actually want to delete the flagged records. How would I go about
>this?
>> The Query Wizard (VFP6) allows me to build a query based on field values
>> but not general record conditions like the deletion marker.
>>
>> Thank you
>> RBryant
>
>