I want to get recent record from table without considering Id or Date
Please Help
I want to get recent record from table without considering Id or Date
Please Help
Well you're going to have to tell us more. We can't guess what your table and field might be.
If you want help, tell us
-what your trying to do exactly,
-show us what you have tried, and
- what errors did you receive (if any)?
Thanks for your quick reply.
I want to fetch recently added record
In table there are 5 field and at every 1 minute entry added in database table
table does't have any primary key or any date field
So I need recent record entry
(Table already created by another person and application is running over that database)
Get some sort of record number on your table. And increment it with each new record.
What does recently mean? In the last week, month,hour???
If getting a recently added record (whatever that might mean) is a requirement, then the database structure is not meeting requirements.
I agree that there are design issues. You can try Last() or DLast(), which I've never had a need for but theoretically find the last record entered:
http://support.microsoft.com/kb/208190
Be cautious of Last, there is a lot of info saying it can not be trusted. DLast may be a better choice.
Regardless, you have a structure issue that you should correct.