Message
From
12/12/2006 08:36:38
To
12/12/2006 08:11:29
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Miscellaneous
Thread ID:
01176801
Message ID:
01176812
Views:
10
>How about:
>
The statement I used in my question is eligible and works fine in the SQL.
DTOS is a Fox function - will be not recognized in SQL ;<
>
>SELECT * FROM tblAbc WHERE DTOS(trans_date) => '20061121' AND DTOS(trans_date) <= '20061127' >>You query Date field and compare it with string, not allowed :o)
The statement I used in my question is eligible and works fine in the SQL.
DTOS is a Fox function - will be not recognized in SQL ;<