by Eugenio Y. (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (9 Votes)
If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions.
This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.
Assumes
It's my first submission after downloading tons of code.. hope it's useful. Vote for it.