Yes, I tried setting both an integer and a text-type of
variable to null, but again it did not change the field.
Setting either type of variable to a value of '0' would put
a zero in the field.

Karen



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




Reply via email to