>>>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
Thanks
Previous
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