|
Home > Archive > FoxPro Help and Support > December 2005 > Capturing "Replace Field"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Capturing "Replace Field"
|
|
| sfarson 2005-12-29, 8:25 pm |
| Using VFP6 and a user is BROWSING a table of data, I let them use the VFP
"Replace Field" utility from the VFP Tools Menu. It is a nice way they can
add value to potentially many records. I can't figure out a way to note if
indeed they did use this utility and change the data in some records with
some field. I need to launch a small routine if indeed they did. Thanks for
any ideas how to capture this.
Thanks, Steve
| |
| Fred Taylor 2005-12-29, 8:25 pm |
| The only way I think that would be possible is if the table belonged to a
database (.DBC) and you had an UPDATE trigger on it.
--
Fred
Microsoft Visual FoxPro MVP
"sfarson" <sfarson@discussions.microsoft.com> wrote in message
news:80A848E2-174F-415E-B82B- C7CF3E962FDA@microso
ft.com...
> Using VFP6 and a user is BROWSING a table of data, I let them use the VFP
> "Replace Field" utility from the VFP Tools Menu. It is a nice way they
> can
> add value to potentially many records. I can't figure out a way to note
> if
> indeed they did use this utility and change the data in some records with
> some field. I need to launch a small routine if indeed they did. Thanks
> for
> any ideas how to capture this.
>
> Thanks, Steve
| |
| Cindy Winegarden 2005-12-30, 8:24 pm |
| Hi Steve,
I second Fred's suggestion. For a nice article (with lots of code) on using
triggers on fields see "I Know Who You Are and I Saw What You Did" by Jim
Duffy (http://msvfp.advisorguide.com/doc/02391). See the panel on the left
side of that page about how to order that article. You can also get Jim's
FoxAudit (http://www.takenote.com/DesktopDefault.aspx?tabid=28) .
--
Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"sfarson" <sfarson@discussions.microsoft.com> wrote in message
news:80A848E2-174F-415E-B82B- C7CF3E962FDA@microso
ft.com...
> Using VFP6 and a user is BROWSING a table of data, I let them use the VFP
> "Replace Field" utility from the VFP Tools Menu. It is a nice way they
> can
> add value to potentially many records. I can't figure out a way to note
> if
> indeed they did use this utility and change the data in some records with
> some field. I need to launch a small routine if indeed they did. Thanks
> for
> any ideas how to capture this.
>
> Thanks, Steve
|
|
|
|
|