Deleted records in a report

How do you stop deleted records from showing in a report? I tried the init
method for the table in the data environment by putting the following code:

set filter to !deleted()

But that stopped the entire report from working.

any ideas?

Thank you.

HME


--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

Andrew
Mon Apr 03 02:07:17 CDT 2006

"HME" <helassaad@comcast.net> wrote in message
news:-fWdnTOlTZbWLq3ZRVn-og@comcast.com...
> How do you stop deleted records from showing in a report? I tried the init
> method for the table in the data environment by putting the following
> code:
>
> set filter to !deleted()
>
> But that stopped the entire report from working.
>
> any ideas?

SET DELETED ON

is the usual way but that is default setting, did you turn it off at some
point?

--
HTH
Andrew Howell

HME
Mon Apr 03 07:29:13 CDT 2006

Andrew,

It is on, and I don't turn it off. On the form, I don't see the deleted
records, however when I preview the report, the deleted records show up.

HME

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com


"Andrew Howell" <ajh@work> wrote in message
news:%23jH0B1uVGHA.3760@TK2MSFTNGP15.phx.gbl...
> "HME" <helassaad@comcast.net> wrote in message
> news:-fWdnTOlTZbWLq3ZRVn-og@comcast.com...
> > How do you stop deleted records from showing in a report? I tried the
init
> > method for the table in the data environment by putting the following
> > code:
> >
> > set filter to !deleted()
> >
> > But that stopped the entire report from working.
> >
> > any ideas?
>
> SET DELETED ON
>
> is the usual way but that is default setting, did you turn it off at some
> point?
>
> --
> HTH
> Andrew Howell
>
>

Cindy
Mon Apr 03 09:53:21 CDT 2006

SET DELETED is scoped to the current data session, so if you're not using a
default data session where you've already set it to your liking then you'll
have to set it in each data session. (Nice use for a Session class.) Also
OFF is the default setting per the VFP9 Help.


--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com


"HME" <helassaad@comcast.net> wrote in message
news:P9Odnc69aJiEiKzZnZ2dnUVZ_s6dnZ2d@comcast.com...
> It is on, and I don't turn it off. On the form, I don't see the deleted
> records, however when I preview the report, the deleted records show up.

>> SET DELETED ON
>>
>> is the usual way but that is default setting, did you turn it off at some
>> point?

TonySper
Mon Apr 03 13:31:12 CDT 2006

I use
REPORT FORM MYFORM FOR !DELETED()
In VFP8 It will not print the deleted records.
TonySper

"HME" <helassaad@comcast.net> wrote in message
news:-fWdnTOlTZbWLq3ZRVn-og@comcast.com...
How do you stop deleted records from showing in a report? I tried the
init
method for the table in the data environment by putting the following
code:

set filter to !deleted()

But that stopped the entire report from working.

any ideas?

Thank you.

HME


--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

HME
Mon Apr 03 16:42:18 CDT 2006

Cindy,

I guess the question now is how to set Deleted to ON for a private data
session?

thanks

HME


--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com


"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:usqKQ7yVGHA.424@TK2MSFTNGP12.phx.gbl...
> SET DELETED is scoped to the current data session, so if you're not using
a
> default data session where you've already set it to your liking then
you'll
> have to set it in each data session. (Nice use for a Session class.) Also
> OFF is the default setting per the VFP9 Help.
>
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "HME" <helassaad@comcast.net> wrote in message
> news:P9Odnc69aJiEiKzZnZ2dnUVZ_s6dnZ2d@comcast.com...
> > It is on, and I don't turn it off. On the form, I don't see the deleted
> > records, however when I preview the report, the deleted records show up.
>
> >> SET DELETED ON
> >>
> >> is the usual way but that is default setting, did you turn it off at
some
> >> point?
>
>

HME
Mon Apr 03 17:02:23 CDT 2006

I figured it out. I put the SET DELETED ON in the init method of the
dataenvironment.

Thanks

HME

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com


"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:usqKQ7yVGHA.424@TK2MSFTNGP12.phx.gbl...
> SET DELETED is scoped to the current data session, so if you're not using
a
> default data session where you've already set it to your liking then
you'll
> have to set it in each data session. (Nice use for a Session class.) Also
> OFF is the default setting per the VFP9 Help.
>
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "HME" <helassaad@comcast.net> wrote in message
> news:P9Odnc69aJiEiKzZnZ2dnUVZ_s6dnZ2d@comcast.com...
> > It is on, and I don't turn it off. On the form, I don't see the deleted
> > records, however when I preview the report, the deleted records show up.
>
> >> SET DELETED ON
> >>
> >> is the usual way but that is default setting, did you turn it off at
some
> >> point?
>
>

Andrew
Tue Apr 04 01:53:52 CDT 2006

"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:usqKQ7yVGHA.424@TK2MSFTNGP12.phx.gbl...
> SET DELETED is scoped to the current data session, so if you're not using
> a default data session where you've already set it to your liking then
> you'll have to set it in each data session. (Nice use for a Session
> class.) Also OFF is the default setting per the VFP9 Help.

A big oops, I was wrong and should have checked.

--
regards
Andrew Howell