>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?
Précédent
Suivant
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