Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

numeric field

Status
Not open for further replies.
Joined
Jul 7, 2003
Messages
95
Location
US
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?
 
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
 
powerprinting

The default value of a numeric field is 0. You might want to check for EMPTY()
Code:
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top