Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Something out of nothing - the aggregate.
Message
From
09/06/2006 07:31:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Something out of nothing - the aggregate.
Miscellaneous
Thread ID:
01128076
Message ID:
01128076
Views:
82
Hello everyone.
Here is the select:
SELECT MIN(Who_Na) as Post_Na FROM Dok1 WHERE Td=38 ;
AND Dok1.D>o_Us.Otchet_d ORDER BY 1 INTO CURSOR Postavshik READWRITE 
When the select finds no matching records in the base table (Dok1) it still returns a result set with one record which contains the null. I see no reason why would one get something out of nothing.
Anyway, is there a universal way to not allow this happen? I had to make the cursor ReadWrite and then to
Replace all Post_Na with Nvl(Post_Na, '') && a kludge!

The number of my selects with aggregate functions is forbiddingly large.
Until your answer comes i will try not to think about the amount of code to dig thru.

All the best.
Kamil
A moment of silence is our cosmic reset button.
Next
Reply
Map
View

Click here to load this message in the networking platform