Tony:
SET EQNULL ON/OFF - neither has an effect on the error.
Ken:
Testing within the Editor, the code as presented returns vtext = 'a-bc';
essentially the correct result when I SET NULL to anything but a
<space> in the On Before Design Action and On Before Start EEPs. Your
code, installed into those EEPs:
SET VAR vspace TEXT = (' ')
SET NULL .vspace
... produces the same error as before
It strikes me that the management of a <space> representing a NULL
within form controls should be segregated from the management of <space>
characters within the form's EEPs. I'm sure there's a means to do so.
Meanwhile, I can work around this by simply not attempting to replace
the <space> via the EEP. Not ideal, but that'll work in this
circumstance.
Thank you both, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
-----------------------------------
112 Harvard Ave #272
Claremont CA 91711-4716
-----------------------------------
[email protected]
-----------------------------------
+011 (909) 238-9012 c
+011 (909) 912-8678 f
------ Original Message ------
From: "Ken Shapiro" <[email protected]>
To: [email protected]
Sent: 1/19/2021 6:58:51 PM
Subject: Re: [RBASE-L] - Form Controls: SET NULL '<space>' confusion
Try this:
set var vspace text = (' ')
set null .vspace
SET VAR vtext = 'a bc'
IF (SLOC(.vtext,' ')) <> 0 THEN
SET VAR vtext = (SRPL(.vtext,' ','-',0))
ELSE
PAUSE 1 USING 'nope - no space here'
ENDIF
RETURN
Regards, Ken
On Tue, Jan 19, 2021 at 9:31 PM Tony Luck <[email protected]>
wrote:
Off the top of my head what effect does setting EQNULL on in the
settings have in a case like this ?
On Wed, Jan 20, 2021 at 12:26 PM Bruce Chitiea
<[email protected]> wrote:
All:
SET NULL '<space> ' (ASCII 032) is often used within On Before
Design and On After Start form EEPs to suppress display of the
default NULL construction '-0-' within form controls.
This presents a conflict when a <space> is entrained within the
user's input, and an On Exit EEP attempts to replace it:
IF vdim_input CONTAINS '<space>' THEN ;
(SRPL(.vdim_input,'<space>','-',0)) ; ENDIF
... produces the error:
-ERROR- NULLs cannot be used in comparisons other than NE or EQ.
(2315)
An attempt to use a "hard" space [alt 255] in place of the NULL
<space> character displays an extended ASCII character in all
VARIABLE LABEL controls containing NULLs; Calibri font, in the
example:
Is there any ASCII code which will reliably suppress display of NULLs
without creating a conflict for routines dealing with ASCII <space>s
in user input? I have not tested for other controls yet.
Thanks!
Bruce A. Chitiea
SafeSectors, Inc.
-----------------------------------
112 Harvard Ave #272
Claremont CA 91711-4716
-----------------------------------
[email protected]
-----------------------------------
+011 (909) 238-9012 c
+011 (909) 912-8678 f
--
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/embdd74890-7f66-4128-836c-71991e072fc1%40pathfinder
<https://groups.google.com/d/msgid/rbase-l/embdd74890-7f66-4128-836c-71991e072fc1%40pathfinder?utm_medium=email&utm_source=footer>.
--
Regards
Tony
--
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/CABnhDARa9M1xxOHrV7p7pY6WhvSdc%3DKcZqggjLrET6wiifwxpA%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CABnhDARa9M1xxOHrV7p7pY6WhvSdc%3DKcZqggjLrET6wiifwxpA%40mail.gmail.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/CADeqk-4xG%3DdQUhsfLbj8%2BQPGoZ7FOXUOaFz3MQqUPQYrkF9-DQ%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CADeqk-4xG%3DdQUhsfLbj8%2BQPGoZ7FOXUOaFz3MQqUPQYrkF9-DQ%40mail.gmail.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/emfbe41d2f-6a49-4751-a6bf-3e0de3f96617%40pathfinder.
