General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
NULL changes from VFP 6 to 7
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only