>>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement