>>The correct SQL syntax is usually :
>>
>>SQLEXEC(1,'SELECT bbjthead where closedate is null','test')
>>
>>SQL Server/Oracle
>
>Thanks. That worked.
>
>Now I'm trying to test for and empty date time field
>and getting a -1 on the SQLEXEC()
>
>SQLEXEC(1,'SELECT bbjthead where closedate is null OR closedate ={}','test')
>
>Once I get that I will test for clsedate is null Or closedate={} and
>the same 2 possible conditions for another field cancldate
>
>SQLEXEC(1,'SELECT bbjthead where (closedate is null OR closedate ={}) AND(cancldate is null OR cancldate ={}) ','test')
>
>Along those lines is it possible to open a SQL Database and use the
>Query build native to FoxPro to build queries then edit them later?
I don't think {} is understood in SQL Server as an empty date. I haven't used Oracle yet. In SQL Server a date is either NULL or 01/01/1900.
DLC