General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL, Null & Cursor/Browse
When using SQL code to populate a cursor, the BROWSE window is often filled with the .NULL. descriptor. While I understand the difference between a NULL field and a ZERO or BLANK data type, my preference for the BROWSE window is to show a "0" in anytime a numeric field is ZERO, NULL or BLANK. Playing around with IIF(ISNULL(condition_A),0,condtion_A), I've been able to get the BROWSE/CURSOR to show ZERO's but this is very tedious and makes the SQL statement hard to ready. Is there a simple way to just instruct FoxPro to display a ZERO anytime a numeric value is .NULL. or BLANK?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only