Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULL changes from VFP 6 to 7
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
NULL changes from VFP 6 to 7
Miscellaneous
Thread ID:
00718730
Message ID:
00718730
Views:
47
What are the changes for null from 6 to 7

I already found that in 6

SELECT * from prebatch LEFT OUTER JOIN accounttransact ;
ON prebatch.icashid = accounttransact.icashid ;
WHERE accounttransact.wayne <> "bobo" ;
GROUP BY accounttransact.cinvoice ;
INTO CURSOR tbatchtmp


returns all the records where wayne <> 'bobo' and where wayne is null

in 7, it works correctly and returns only records where wayne <> 'bobo' (ex: wayne = 'PH')

evidently, null <> 'bobo' = .T.

Are there any other gotchas?
Next
Reply
Map
View

Click here to load this message in the networking platform