what is the bug in the statement
-
-
hi there, im using ado in vc++ for access db i have used this query but it shows "data type mismatch in critria expressing" SELECT * from FDetails where ddate = '05/29/2006' ddate is datetime field any one has solution for this problem regards, Gan
Maybe
SELECT * from FDetails where ddate = "05/29/2006"orSELECT * from FDetails where ddate = #05/29/2006#I believe this is not a post for the ATL/WTL/STL group...:^) --- With best regards, A Manchester United Fan The Genius of a true fool is that he can mess up a foolproof plan! -
hi there, im using ado in vc++ for access db i have used this query but it shows "data type mismatch in critria expressing" SELECT * from FDetails where ddate = '05/29/2006' ddate is datetime field any one has solution for this problem regards, Gan
Something like this: SELECT * from FDetails where to_char(ddate, 'mm/dd/yyyy') = '05/29/2006'
-
Maybe
SELECT * from FDetails where ddate = "05/29/2006"orSELECT * from FDetails where ddate = #05/29/2006#I believe this is not a post for the ATL/WTL/STL group...:^) --- With best regards, A Manchester United Fan The Genius of a true fool is that he can mess up a foolproof plan! -
hi there, im using ado in vc++ for access db i have used this query but it shows "data type mismatch in critria expressing" SELECT * from FDetails where ddate = '05/29/2006' ddate is datetime field any one has solution for this problem regards, Gan
;)Hi Gan,You have not any mistake in the query, But problem may there if your format in oracle registry is different.check the registri. For urjent you can find by using like statement for date field. Thanks Pramod. Pramod Kumar Dhal.CMS Computers ltd.,Mumbai.