Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP9 NULL values
Message
From
06/04/2005 18:34:10
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01001888
Message ID:
01002113
Views:
35
>The problem is the following code. In VFP6 it returns _tally = 0, in VFP9 it returns _tally = 1 with .NULL. in dchg[1]. What can I do about the _tally? There was not a match found in the DRAW but _TALLY returns a 1 and puts .NULL. in the array. Why does this happen and what can I do about it?
>
SELECT NVL(MAX(draw.drawlstchg),{}) FROM draw ;
	WHERE draw.obligor + draw.obligation + draw.unit = ;
	m.obligor + m.obligation + m.unit ;
	INTO ARRAY dchg
Previous
Reply
Map
View

Click here to load this message in the networking platform