We have a new user in the company, so of course we're finding new bugs.  The most recent is that she has been including the semicolon when she stores data, and then when other databases do Lookups to her data everything gets shifted a field. (I use @XListValues to group lookup data.)

So I'm looking for a way to lock out the semicolon when users Add or Update a record.  The following works fine to do this:

 Workorder - On-Form-Entry

// Disables the use of the semicolon in Add or Update mode for non-Admins
IF NOT sGroup = "Admin"
THEN
{
	IF @Mode() = 0 or @Mode() = 1
	THEN
		{
		IgnoreKey(59,0)
		}
	ELSE IF @Mode() = 2
	THEN
		{
		ClearIgnoreKey(59)
		}
} 

However, that last bit, the "Else" to clear the ignore key state when the user is in Mode 2 (Search), does not work.  The ignored key is persistent.

I tried adding this to On-Retrieve-Spec-Open:

ClearIgnoreKey(59) 

but this also does not clear the persistent ignored state.  What am I overlooking?

Hello Scott,

IgnoreKey is probably not going to be the way to do this, as the user can have both Add and Search open at the same time. So if the user opens Add Mode, then opens Search, the semi-colon would work in both Add and Search modes.

What you can do is check the record before it is saved on Form Exit and remove Semi-colons from the field data if there is any.

-Ray

Quote:


Problem is, it could occur in any of dozens of fields, in any of a half-dozen databases which contain lookup-fodder.

OK, I've changed my mind.  Instead of putting the cleaning routine in the Save buttons, I've put it in each element's on-element-change event, so it will only run when necessary.  I've used ThisElement and tossed it into Global code as a subroutine.  Seems to be working well.

I would still like, if Ray, Mark or Erika has a moment or two, some hand-holding with the SetStringArraySeparator command, which I have never used before.  Seems like a nifty bit of code which will solve a lot of problems and will reduce my total code amount when I institute it.  Can it be used in the Application programming?  If not where should it go?  And do you have any advice on which character I should specify as a replacement for the semicolon?  Can I use an accented character from the high-bit set, such as Ě?  If so, how would I specify it in the command?  I've already discovered that the Program Editor doesn't like Ě, so this doesn't work:

var vNewSep as String = "Ě"
SetStringArraySeparator( vNewSep ) 

which leads me to believe that the high-bit set cannot be used, even if I could figure out how to reference it.  Maybe the pipe symbol | ?  I don't think my users would use that one, but you can never tell, they're a perverse bunch.

OK, I'm starting to ramble; it's past time for my nap.

Thanks for your help.

Thanks Ray I'll give it a try!