Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL, Null & Cursor/Browse
Message
From
05/03/2004 19:21:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL, Null & Cursor/Browse
Miscellaneous
Thread ID:
00883729
Message ID:
00883729
Views:
43
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
Map
View

Click here to load this message in the networking platform