I finally got around to trying this and it still doesn't work. I am unable
to use a PROPERTY ... TEXTVALUE command to "null out" a DBEdit
that is based on an Integer column. It ignores TEXTVALUE '',
TEXTVALUE ' ', your (char(160))... It will only put an actual value in
there, such as a '0', but this breaks a constraint I have on the field.
Has anyone been able to null out an integer DBEdit on an integer
field? Razzak, should we be able to do this?
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
>
>
>
