|
Karen
COuld you post the actual code you
used?
Was it this?
SET VAR vsp = (CHAR(0))
PROPERTY dbedummy set_focus 'TRUE'
PROPERTY
dbedummy textvalue .vsp
RETURN
----- Original Message -----
Sent: Thursday, January 20, 2005 12:02 PM
Subject: [RBG7-L] - Re: Using Property command on integer field -
SOLUTION
Mike:
You did it! Setting it to (CHAR(0)) allowed the integer
DBEdit field to be "nulled" out. I couldn't find any other method
of doing so. I might report it as an "enhancement" that you can
null it out with a TEXTVALUE '' like you can if it was a text
dbedit.
Thanks a bunch!
Karen
SET VAR vsp = (CHAR(160))
PROPERTY dbedummy set_focus 'TRUE'
PROPERTY dbedummy textvalue .vsp
RETURN
----- Original Message
-----
From: <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List"
<[email protected]>
Sent: Thursday, January 13, 2005 6:12 PM
Subject: [RBG7-L] - Using Property command on integer field
>
> My Synagogue client (you know, "do it THEIR way") is
so happy
> with my 7.1 app that I'm now deep in developing another app
for
> them. This one is much more complicated than the other and
I'm
> running into several problems.
>
> I have an
Integer DBEdit where there's an entry eep (custom code)
> that brings
up a popup menu under certain conditions, erases what's
> in the field
under other conditions. The first part works -- if they pick
>
from the popup there is a:
> PROPERTY dbeListNo
TEXTVALUE .vList
> that puts the value into that field. But I
also want that entry eep to
> erase what might be already in the field
under other circumstances.
> I've tried
>
PROPERTY dbeListNo TEXTVALUE ' ' (with a
space)
> PROPERTY dbeListNo TEXTVALUE ''
(with no space)
>
> SET VAR vList
INTEGER = NULL (also TEXT = NULL)
> PROPERTY
dbeListNo TEXTVALUE .vList
>
> It will NOT null out this field.
The only thing that works is to assign the
> field a '0'.
That works fine! But unfortunately it breaks a constraint so
> I can't have a '0' in the field. How do you erase an Integer
DBEdit field?
>
> Karen
|
