Sometimes, new Visual Basic developers may meet such problems as retrieving data by date. Just need to use # to make it right
e.g.
db.Execute "DELETE FROM table_name WHERE FieldDate < #" & Format(Date, "yyyy/mm/dd") & "#"
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Error : Error detected by database DLL This error occurs when trying to open report produced using Crystal Report in application, one of whi... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
Error: Creation of the virtual directory http://localhost/web failed with error: Could not find the server 'http://localhost' on the... -
Error: Message: The server was unable to process the request due to an internal error. For more information about the error, either turn o...
0 comments:
Post a Comment