Hi Razzak, your example is just what I was looking for. Like Tom I use a scrolling region. It works fine when I leave the DB Edit field within the same row, the On Exit EEP works as expected. But when I leave the DB Edit field by F7 or F8 or by click into the next row (within the same column), the EEP does not fire. Finally I'm looking for a possibility to return to that DB Edit field, where there is the wrong amount. What would be the best way? Who would be able to help? Regards Armin
> Date: Thu, 29 May 2008 01:23:30 -0400> To: [email protected]> From: [EMAIL > PROTECTED]> Subject: [RBASE-L] - Re: Checking a value> > At 12:09 AM > 5/29/2008, TOM HART wrote:> > >I have a form with a scrolling region and want > to check a> >currency value upon exiting a row. I do not want a null> >or > zero value. Currently I use a rule to check if the> >value is less than 1. > This works, but does a rule slow> >down a multi-user environment, if so I'm > sure there is a> >better way.> > Tom,> > GETPROPERTY <CurrencyColumnCompID> > TEXTVALUE 'varname' is> one of the techniques to validate a value when > existing a> row or leaving a field.> > Here's how:> > -- A very simple > example> -- start here ...> CLEAR VAR vCheckValueTxt, vCheckValueCur> SET VAR > vCheckValueTxt TEXT = NULL> SET VAR vCheckValueCur CURRENCY = NULL> > GETPROPERTY <CurrencyColumnCompID> TEXTVALUE 'vCheckValueTxt'> SET VAR > vCheckValueCur = (FLOAT(.vCheckValueTxt))> IF vCheckValueCur > 0.00 THEN> -- > All good ...> -- Do what you need to do here ...> ELSE> PAUSE 2 USING 'Amount > must be greater than 0.00' ICON STOP> RETURN> ENDIF> -- end here ...> > > That's all there is to it!> > Have fun.> > Very Best R:egards,> > Razzak.> > > --- RBASE-L> ================================================> TO POST A > MESSAGE TO ALL MEMBERS:> Send a plain text email to [email protected]> > > (Don't use any of these words as your Subject:> INTRO, SUBSCRIBE, > UNSUBSCRIBE, SEARCH,> REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)> > ================================================> TO SEE MESSAGE POSTING > GUIDELINES:> Send a plain text email to [email protected]> In the message > SUBJECT, put just one word: INTRO> > ================================================> TO UNSUBSCRIBE: > Send a > plain text email to [email protected]> In the message SUBJECT, put just one > word: UNSUBSCRIBE> ================================================> TO > SEARCH ARCHIVES:> Send a plain text email to [email protected]> In the > message SUBJECT, put just one word: SEARCH-n> (where n is the number of > days). In the message body, > place any > text to search for.> > ================================================> > _________________________________________________________________ Lustige Emoticons für Ihren Messenger! Hier kostenlos downloaden! http://messenger.live.de/mein/
