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
 Development Tools
 ASP.NET
 recordset

Author  Topic 

ranganath_mehta
Starting Member

4 Posts

Posted - 2002-08-29 : 08:18:32
Hi Guys/Gals,

I have a query which returns me a single tupple when executed from SQL QUery Analyser, but when i use the recordset object in VB to execute the same query i get an error message reading "Either EOF / BOF is true".

I cant understand why this happens. Wud be grateful if someone can help me out.

Regards

Ranganath

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-08-29 : 09:25:11
Perhaps a parameter isn't getting sent correctly resulting in an empty recordset. Just a guess.

Go to Top of Page

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-08-29 : 11:00:35
What is this single tupple ? Is it the recordcount ?

Paul
Go to Top of Page

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2002-08-29 : 11:47:48
i thought a tupple is half a byte ... 4-bits

Go to Top of Page

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-08-29 : 12:09:46
You're thinking of a nibble

Paul
Go to Top of Page

Nico
Starting Member

18 Posts

Posted - 2002-08-30 : 23:52:31
You prolly need to set the cursor to the first record before attempting any operations on the recordset (MoveFirst?). Or perhaps you need to open it first.

Kind regards,
Nico

Go to Top of Page
   

- Advertisement -