[RBG7-L] - Re: Using Property command on integer field

[David M. Blocker]

Karen   Have you tried this?:   SET VAR vIntVar = NULL PROPERTY componentid TEXTVALUE .vIntVar   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Thursday, January 20, 2005 9:44 AM Subject: [RBG7-L] - Re: Using Property command on integer field Mike: 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" <rbg7-l@rbase.com> 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 > > >