Dan:
I'm reading you to mean that the dash character is the only
non-alphanumeric you want the dbEdit to accept (e.g. no '#', '%' etc.);
and that the dash character is not necessarily present.
In mask terms, this suggests a mask with a string of 'c' (arbitrary
characters permitted, but not required) spanning the width of the
column, capable of accepting ANY character in ANY position and ANY total
character count. There appears to be no ability WITHIN the mask to
weed-out all non-alphanumerics besides the dash. There's always the
approach of putting a validation routine in the On Exit EEP which
converts any non-dash to a dash, but this introduces an opportunity for
damage if the operator mistakenly enters, say, an underscore, in a
position intended for an alphanumeric.
If your users are hitting a column of existing part numbers, how about
substituting a DBLookupComboBox with a type-ahead in place of the
DBEdit? All entry issues solved. In your distributed environment, this
could always be initialized as a per-user temp table for performance
purposes. On the other hand, if this is about a new entry into the
column ... more thought required.
Has the Great Mojave heated up yet?
Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "'Dan Goldberg' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 6/17/2024 10:42:36 AM
Subject RE: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain
characters
It is a single text field that will only accept A-Z, a-z, 0-9, or dash
character. It can vary in length.
So it can be
123A-1
23a
35a33
Etc
Dan Goldberg
From:[email protected] <[email protected]> On Behalf Of
Bruce Chitiea
Sent: Monday, June 17, 2024 9:58 AM
To:[email protected]
Subject: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain
characters
Dan:
In the dbEdit control Properties, on the Effects tab, have you beat on
the "Input Format Mask"?
But questions:
- Are you looking to restrict entry of certain characters [e.g. 'A' but
not 'a' | 'Aa'-'Yy' but not 'Zz' | 0-8 but not 9 ]?
- Are you looking to enter numbers, letters and dash(-) all within the
same dbEdit control, or separate controls?
- Do you mean numbers of INTEGER datatype, or ALPHANUMERIC digits?
- Are you looking to combine numbers of INTEGER datatype with ALPHA
text?
Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "'Dan Goldberg' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 6/17/2024 9:46:42 AM
Subject [RBASE-L] - restricting a db edit to certain characters
I need to limit a db edit field in a form to only numbers, letters and
dash(-). I am not having much luck trying to figure it out.
I am wondering if anyone else has done this? If so, maybe can you
share some details?
TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027FBB9B273FA60A5E607CCD4CD2%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027FBB9B273FA60A5E607CCD4CD2%40BY3PR19MB5027.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em17ac21e3-5fba-4e8f-aba6-0753079d0501%40382da8cb.com
<https://groups.google.com/d/msgid/rbase-l/em17ac21e3-5fba-4e8f-aba6-0753079d0501%40382da8cb.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027DA3E1E76DE53783B9537D4CD2%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027DA3E1E76DE53783B9537D4CD2%40BY3PR19MB5027.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emadeb8ccf-dece-4d20-86c7-1e8bc800c150%40382da8cb.com.
