Null fields in QBE

[cobweb]

Hello there:

Hopefuly a quick and easy question:

I want to run a query that finds all null values in a numeric field and replace them with zero (so they add up in Crystal!)
The table is brought in from elsewhere so setting default values of zero only appears to work the first time.

I am using QBE - will visual query designer do as well (paradox 9)?


Thanks in anticipation!

 

[Langley]

put this in the query field:

blank, changeto 0

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[Langley]

To keep from having to do this in the future, try setting a default value of 0 for that field at the table level. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[cobweb]

Thanks for that; "Null", "IsNull" and " " were getting me nowhere!I did try setting 0 as a default but inserting new rows just seemed to bring blanks in; maybe my mistake somewhere?

Thanks Again

 

[Langley]

It seems to me that there is a setting for treating nulls as zeros in the BDE or the preferences somewhere. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Actually, it's a Paradox Setting. You'll find it on the Database tab of the PReferences dialog. Also, you can control it via ObjectPAL using setBlankAsZero( TRUE ).

Hope this helps...

-- Lance