Bug while using Between for Date Fields [message #325362] |
Fri, 06 June 2008 00:34  |
Preeti_Mathur
Messages: 4 Registered: June 2008
|
Junior Member |
|
|
I am creating an application, where Oracle 9i is been used as the backend, and the fornt end is VB6.0
I had VB Service Pack installed at my system.
Now when i execute the following query from SQL Plus, i get the correct O/P, as my requirement, but when i execute the same query from the application frontend then the desired records are not received there, that is the RecordSet is not been populated there.
I had used ADODB Connection and Recordset to execute the query.
The query is:
"Select BirthDate from EmpMaster where BirthDate between '01-Jan-08' and '31-Jan-08'"
I had also installed the providers for Oracle9i on my system.
Any help will be highly appreciated.
Thanking You all in advance.
|
|
|
|
|
|
|
|
|
|