You shouldn't use an = sign for NULLS. NULL does not equal NULL. Something that is undetermined cannot equal something else that is undetermined.
Best to use
IF ISNULL(field)
BLANK Field
ELSE
Thisform.refresh
ENDIF
>VFP 3.0
>
>Hello All,
>
>I have a weird one here folks....ok here goes
>
>I have a browse form...when the form opens it searches the dbf for
>a number, locates the record, then continues to search the dbf for
>another field that is a character field, once it is located the record
>displays and everyone signs happy happy joy joy.
>
>The problem is the second field, when the value is .null the dbf displays
>the wrong record.
>
>I know i have to do something about the null and have tried to no avail.
>
>any thoughts? I am thinking something like this..
>
>IF field=.null.
>BLANK field
>ELSE
>THISFORM.REFRESH
>
>Thanks and have a good day.
>
>Becky
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement