numeric field

[powerprinting]

I have a numeric field my database. The data is populated with any number from 0 on up. However, sometime the field is blank, containing no numbers at all. What syntak will isolate the blank records. Everything I try to do evalutes the blank record as being a 0. I dont want a 0 in that field. Any suggestions?

 

[powerprinting]

I think I solved my own problem. I used set filter to isblank(payoff)... only blank records are showing. Hopefully this is my best way.

Thanks

 

[Mike Gagnon]

powerprinting

The default value of a numeric field is 0. You might want to check for EMPTY()

CREATE CURSOR my (field1 n(1))
GO bott
APPEND BLANK
? field1  && Gives zero 
? EMPTY(field1) && .T.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[powerprinting]

Thanks Mike, that should work better