Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to convert null values to 0 & spaces in views
Message
From
17/08/2000 23:57:15
Rajesh Halyal
Raj Software
Sangli, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to convert null values to 0 & spaces in views
Miscellaneous
Thread ID:
00406508
Message ID:
00406508
Views:
67
I have a view which links 3 tables A B C.
A is the header
B is child table
C is child child table

The view selects all fields and creates one record per in A and releated records in B and child records in C if any.
If there are no child records in C all the fields are show NULL.
If I use this view in report all the total fields fail asn .NULL. any thing is .NULL.

Rajesh
Next
Reply
Map
View

Click here to load this message in the networking platform