Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP9 NULL values
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01001888
Message ID:
01002050
Views:
34
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 MAX(draw.drawlstchg) FROM draw ;
	WHERE draw.obligor + draw.obligation + draw.unit = ;
	m.obligor + m.obligation + m.unit ;
	INTO ARRAY dchg
IF _tally > 0
	m.dlstchg = dchg[1]
ELSE
	m.dlstchg = {  /  /  }
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform