Solved

RecordCount = -1 (???)

Posted on 2000-04-17
5
218 Views
Last Modified: 2010-04-04
Something "strange" in D5 and Oracle7.3.4. The application runs a SELECT statement in a table which contains VARCHAR2(2000) fields. Well... sometimes (only SOMETIMES) I get a RecordCount with value = -1 (negative 1). Any idea?
0
Comment
Question by:binho
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 

Author Comment

by:binho
ID: 2722420
Motaz: sure it is opened. That's when it returns -1.
0
 
LVL 13

Accepted Solution

by:
Epsylon earned 100 total points
ID: 2722494
Here is a link that relates to this:

http://www.borland.com/devsupport/sqllinks/pub-52.html


Another thing you could try is to call 'FetchAll' before you read 'RecordCount'. However this could be slow...

Regards,

Epsylon.
0
 
LVL 7

Expert Comment

by:Motaz
ID: 2722368
Make sure that the DataSet is opened
0
 

Author Comment

by:binho
ID: 2722532
I just found out that it returns -1 only when the number of rows returned is greater than 10. If the # is eleven, then I get -1.
0
 

Author Comment

by:binho
ID: 2722565
Calling FetchAll before reading RecordCount solve the problem :))
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question