or if the user click exit revert the changes, he/she has had the choice to
cancel what he/she is doing. We use buffering and this allows us to revert
any changes if the user wants to before a save...we never directly update
the table after the user has left the field.
Shawn Dorion
Product Development
Our Software Ltd.
Telephone: 613.657.4422
Toll Free : 1-800-675-8255
Fax: 613.692.4828
mailto:Shawn (AT) OurSoftware D.OT com
Our Software Ltd
Visit us at www.OurSoftware.com
"Proven, Powerful and Highly Effective Employee Resource Management for
Public Safety Organizations"
This message is intended to be viewed only by the specified recipient(s) it
is addressed to. It may contain confidential and/or privileged information
that is intended for company use and is exempt from disclosure under
applicable law. If you are not the intended recipient of this message, or
this message has been sent from an unauthorized source consider this
notification stating that dissemination, publication, and reproduction of
this communication is strictly prohibited. If you have received this message
in error please notify Our Software immediately by email at
OSL@OurSoftware.com. Thank You.
> -----Original Message-----
> From: profox-bounces (AT) leafe D.OT com [mailto:profox-bounces@leafe.com]On
> Behalf Of Dominic Burford
> Sent: Friday, October 31, 2003 10:37 AM
> To: ProFox Email List
> Subject: RE: Restrict Textbox Values?
>
>
> << No wonder I don't use fields as controlsources.
>
> This is where buffering comes in. And that's why any form should
> always check for changes before closing and give the user the
> option to either save or cancel those changes. It's just good practice.
>
> Regards
>
> Dominic Burford
> Software Engineer
>
> Pegasus Software Limited
> Orion House, Orion Way, Kettering, Northamptonshire, NN15 6PE
>
> * Tel: +44 (1536) 495074
> * Fax: +44 (1536) 495001
> * dominic.burford (AT) pegasus D.OT co.uk
> * http://www.pegasus.co.uk
>
> "I conclude that there are two ways of constructing a software
> design: One way is to make it so simple there are obviously no
> deficiencies, and the other way is to make it so complicated that
> there are no obvious deficiencies." -- Tony Hoare, Turing Award
> Lecture 1980
>
> -----Original Message-----
> From: Cotton Mr Jerry P [mailto:CottonJP.CTR@2mawcp.usmc.mil]
> Sent: 31 October 2003 15:29
> To: 'ProFox Email List'
> Subject: RE: Restrict Textbox Values?
>
>
> I guess my problem with this is having a field as a control source. I can
> envision modifications being made to a table, the user getting
> some kind of
> error in the lostfocus and just canceling out of the form. Now a
> record has
> been updated in the table but the user thinks he cancelled what
> he started.
>
> No wonder I don't use fields as controlsources.
>
> Jerry Cotton, MCP
> 2nd Marine Aircraft Wing
> Management Training and Assistance Team
> Cherry Point, NC 28533
> (252)466-4854
> mailto:cottonjp.ctr (AT) 2mawcp D.OT usmc.mil
>
>
> > -----Original Message-----
> > From: Ed Leafe [mailto:ed@leafe.com]
> > Sent: Friday, October 31, 2003 9:57 AM
> > To: ProFox Email List
> > Subject: Re: Restrict Textbox Values?
> >
> >
> > On Friday, October 31, 2003, at 09:48 AM, Cotton Mr Jerry P wrote:
> >
> > > Let me get this straight. You're saying that the data gets
> > written to
> > > disk
> > > in the Valid and that you can't revert it in the lostfocus.
> > Are you
> > > saying
> > > that you would allow code to prevent a control from losing
> > focus but
> > > the
> > > data was already written to disk. Doesn't sound to kosher to me.
> >
> > If valid returns .T. or a non-zero numeric value, the
> > ControlSource is
> > updated with the contents of the control at that point. If the
> > ControlSource is a field in a cursor, that field is updated
> > then. With
> > buffering, LostFocus could possibly revert it to its original
> > unchanged
> > value, but it is severely limited - it can only revert or accept. If
> > there was an intermediate value, it's gone by the time LostFocus()
> > fires.
> >
> > ___/
> > /
> > __/
> > /
> > ____/
> > Ed Leafe
> > http://leafe.com/
> > http://opentech.leafe.com
> >
> >
[excessive quoting removed by server]
©2003 Shawn Dorion |
