>Hi!
> Now I'm trying to test for and empty date time field
> and getting a -1 on the SQLEXEC()
>
>Sorry I'm not sure what you mean.
>But heres a guess...If you want the closedate to be empty you can put it
>in a s text i.e.closedate='12\10\98'
>so an empty date might be ='' or ' ' however {} is not correct.
>Try:
>LSQL='set dateformat mdy'+CHR(13)
>LSQL=LSQL+"SELECT bbjthead where closedate is null OR closedate =''"
>SQLEXEC(1,LSQL,'test')
>
>Once I get that I will test for closedate is null Or closedate={} and
>the same 2 possible conditions for another field cancldate
>OK Try:
>LSQL="SELECT bbjthead where (closedate is null OR closedate ='')"
>LSQL=LSQL+" AND (cancldate is null OR cancldate ='')"
>SQLEXEC(1,LSQL,'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?
>
>No not in the way I think you mean. But in the files section I saw
>some query builder.
>I build inserts and updates on the fly from the table and cursor descriptions
>if you want this let me know.
>
>I know use Visual InterDev 6.0 in Visual Studio 6.
>I reccomend it if your in VS 6 already.
>You can build queries and stored procedures by using drag and drop
>ect. It's very nice.
>See the article around
>http://msdn.microsoft.com/developer
>for more info.
>
>Good Luck!


Thanks