Access Database is omitting the very first record and it returns the rest of the records
-
For many years I have been using vb6 with Access Database as back end. In many cases while returning record sets Access is omitting the very first record and it returns the rest of the records. I am really baffled. Please help. Hi all of you, I have corrected my mistake and got the answer for this question. Here is how I got it solved. The records were stored with time field. When querying up I did not mention the begining of the starting day (like 00:01 - which implies the start time of the day) and the end of the day in the finishing date. (Thought up this solution very late.) And so I was getting a few records eliminated from the query result set. Thanks for all of you who tried to help and you can consider my question closed. Hope this helps somebody.
-
For many years I have been using vb6 with Access Database as back end. In many cases while returning record sets Access is omitting the very first record and it returns the rest of the records. I am really baffled. Please help. Hi all of you, I have corrected my mistake and got the answer for this question. Here is how I got it solved. The records were stored with time field. When querying up I did not mention the begining of the starting day (like 00:01 - which implies the start time of the day) and the end of the day in the finishing date. (Thought up this solution very late.) And so I was getting a few records eliminated from the query result set. Thanks for all of you who tried to help and you can consider my question closed. Hope this helps somebody.
Are you confusing zero-based and one-based indexing for arrays? Otherwise, showing some code might help us help you. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
Getting an article published on CodeProject now is hard and not sufficiently rewarded.
-
For many years I have been using vb6 with Access Database as back end. In many cases while returning record sets Access is omitting the very first record and it returns the rest of the records. I am really baffled. Please help. Hi all of you, I have corrected my mistake and got the answer for this question. Here is how I got it solved. The records were stored with time field. When querying up I did not mention the begining of the starting day (like 00:01 - which implies the start time of the day) and the end of the day in the finishing date. (Thought up this solution very late.) And so I was getting a few records eliminated from the query result set. Thanks for all of you who tried to help and you can consider my question closed. Hope this helps somebody.
Whatever it returns first is the first. Or maybe you're using it wrong.