----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> 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. Well Null is (Char(0)).. Have you tried that. > 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 > > > > > > > > > > > > > >
