Hello
I am using VB 6 to program a Access 2003 type database file. This is the code that creates the sql expression
Code:
ssql = "select * from tblraw where (tblraw.rawdate=#" & thisdate & "#) and (tblraw.rawcn=" & Trim(Str(thiscow&)) & ") order by tblraw.rawdate,tblraw.rawtime"
Typically the sql string looks like this :
select * from tblraw where (tblraw.rawdate=#10/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime
the above statement returns 12 records, which is correct
however if the string looks like this :
select * from tblraw where (tblraw.rawdate=#09/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime
or this :
select * from tblraw where (tblraw.rawdate=#9/10/2012#) and (tblraw.rawcn=2482) order by tblraw.rawdate,tblraw.rawtime
then zero records are returned, although they exist in the database file. I find this most unfair.
Thank you for any help in advance
John