
Visual Basic RDO and SQL Server 6.5 null Problem
Quote:
>Hello,
>An application that runs fine with SQL Server 6.0 uses Visual Basic 4.0 RDO
>(RDO-Patch applied) to access the data. Under SQL Server 6.5 (U.S. with
>Service Pack 1) a select statement using a null in the where clause does
>not work (select * from x where y = null).
>Has anyone experienced this problem or knows of a solution?
Yes. And there is a comprehensive article on this problem somewhere in
MS KB. In two words, you have to use the syntax of IS NULL, e.g.
select * from x where y is null
(or select * from x where NOT y IS null)
This is claimed to be a "more ANSI" syntax, and acquired habits and
practices of developers do not count... So, where do you want to go
today?