either BOF or EOF is true - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

either BOF or EOF is true

Author

Topic

saravnan.16
Starting Member

2 Posts

Posted - 2012-08-03 : 04:02:36

SQL: SQL SERVER 2008 EXPRESS EDITION
OS: WINDOWS 7
APPLICATION: VB

1.In our office, we are facing the following error when we try to open a report in our application:

"Either BOF or EOF is true or the current record has been deleted. Requested operation requires a current record."

2. The same error appears when logging in another module/application but the module is working fine.

SA VALPARAI

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-08-03 : 07:00:03

Without seeing ANY code (vb OR sql server), there is no way to tell what the problem is.

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

saravnan.16
Starting Member

2 Posts

Posted - 2012-08-03 : 07:36:48

Sir i am very new to use sql server so i am not able to understand the code details. Moreover i have basic idea about working in VB application and can alter some of Database tables manually. But not by queries.

If you guide me how to see that query in application or some clue regarding that i will be able to produce the same here.

Thanks and Regards,
Saravanan R

SA VALPARAI

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-03 : 08:04:22

That message sounds like it is coming from and ADO record set while traversing the record set. Is this an application that has been working all along, and suddenly stopped working?

I would run the code in Visual Studio in debug mode and look for the place where the exception is appearing. See if you are going past the end of the record set or whether you are trying to access a record set before it is open or after it is closed.

The other possibility is that it is a multi-threaded application and another thread is deleting a record set. But before I look at that angle, I would do the simple checks that I mentioned in my previous paragraph.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources