>How handle a datetime field in the where part.
>This is not a foxpro database, so dtos will not work
>
>
>example
>q = sqlconnect("testa")
>=sqlexec(q,"select * from test where newdatet>"+??? ,"Mycursor")
You should use functions which are supported by your back-end, e.g. on SQL_Server it's usually Datepart function.
Edward Pikman
Independent Consultant