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


Reply via email to