 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / August 2003Recordset.Recound = -1
Hi as propably anyone knows RecordCount of ADO Recordsets doesn't work reliable. In many cases I get "-1" as the result. Does someone knows hoe to solve this problem ? And another question: is it possible to something like that in one SQL string "SELECT Count(*),* FROM Table" ? I know that the syntax above doesn't work, but can I count all recordset and get them back in one step, that would solve the RecordCout problem in many cases. I would highly appreciate any idea. Jonas Jonas, Read this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdap ro05_9.asp Try changing the cursor location. David P. > Hi > [quoted text clipped - 13 lines] > > Jonas Hi David thanks for your fast reply. I took another cursor type, from originally ForwardOnly to Static, and it work fine. Jonas > Jonas, > > Read this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdap ro05_9.asp > Try changing the cursor location. > [quoted text clipped - 18 lines] > > > > Jonas |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.